If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Trying to get a blank cell presented if B26=0
IF B26=0, how do I present a blank cell in another place, or put an amount if
not true. I have used =IF(B26=0,0,Sheet1!E2) , but I get a $0.00 figure which I do not want. Even I if I used a blank cell for the true portion, I get then same $0.00 figure. I get the right amount for false. I am preparing an excel program for a small plowing business. |
#2
|
|||
|
|||
Trying to get a blank cell presented if B26=0
Hi,
Try this =IF(B26=0,"",sheet1!E2) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "dennis" wrote: IF B26=0, how do I present a blank cell in another place, or put an amount if not true. I have used =IF(B26=0,0,Sheet1!E2) , but I get a $0.00 figure which I do not want. Even I if I used a blank cell for the true portion, I get then same $0.00 figure. I get the right amount for false. I am preparing an excel program for a small plowing business. |
#3
|
|||
|
|||
Trying to get a blank cell presented if B26=0
=IF(B26=0,0,Sheet1!E2)
Try it like this... =IF(B26=0,"",Sheet1!E2) -- Biff Microsoft Excel MVP "dennis" wrote in message ... IF B26=0, how do I present a blank cell in another place, or put an amount if not true. I have used =IF(B26=0,0,Sheet1!E2) , but I get a $0.00 figure which I do not want. Even I if I used a blank cell for the true portion, I get then same $0.00 figure. I get the right amount for false. I am preparing an excel program for a small plowing business. |
#4
|
|||
|
|||
Trying to get a blank cell presented if B26=0
"dennis" wrote:
IF B26=0, how do I present a blank cell in another place, or put an amount if not true. I have used =IF(B26=0,0,Sheet1!E2) Ostensibly, you would write: =IF(B26=0,"",Sheet1!E2) But you wrote: Even I if I used a blank cell for the true portion, I get then same $0.00 figure. That sounds like you tried the above, and it did not work for you. So I suspect you are not being precise enough in the description of your problem. Taking a wild-ass guess, I wonder if you really want: =IF(OR(B26=0,Sheet1!E2=""),"",Sheet1!E2) I am even suspicious of the test B26=0. That is what you say you want. But I wonder if that stems from your misunderstanding of some original problem. If so, we can help you further if you would show the formula, if any, in B26, and if you would explain why this formula should return a null string when B26 is zero. ----- original message ----- "dennis" wrote: IF B26=0, how do I present a blank cell in another place, or put an amount if not true. I have used =IF(B26=0,0,Sheet1!E2) , but I get a $0.00 figure which I do not want. Even I if I used a blank cell for the true portion, I get then same $0.00 figure. I get the right amount for false. I am preparing an excel program for a small plowing business. |
#5
|
|||
|
|||
Trying to get a blank cell presented if B26=0
If residing in Eastern US you must be making a fortuneg
Gord On Sat, 13 Feb 2010 09:04:01 -0800, dennis wrote: I am preparing an excel program for a small plowing business. |
Thread Tools | |
Display Modes | |
|
|