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.

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.

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.

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.

Trying to get a blank cell presented if B26=0
 

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


Gord

On Sat, 13 Feb 2010 09:04:01 -0800, dennis
wrote:

I am preparing an excel program for a
small plowing business.