Trying to get a blank cell presented if B26=0

[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.

 

[Mike H]

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.

 

[T. Valko]

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

Try it like this...

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

 

[Joe User]

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)

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

 

[Gord Dibben]

If residing in Eastern US you must be making a fortune<g>


Gord