Trying to get a blank cell presented if B26=0

  • Thread starter Thread starter dennis
  • Start date Start date
D

dennis

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.
 
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 said:
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)
Click to expand...

Ostensibly, you would write:

=IF(B26=0,"",Sheet1!E2)


But said:
Even I if I used a blank cell for the true portion,
I get then same $0.00 figure.
Click to expand...

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 -----
 
Back
Top