IF STATEMENT

[Omer]

Hi,

The formula I have in B3 is "IF(S131*(L131-
L132>0,"NO","YES")" -->> IT is the same formula I have in
B1 and B2.

The problem is Excell calculates B3 even when there is no
value in Column A. (See below). I would like B colum to
stay Blank until a value is entered.

Thanks for the help
Omer

A B

-0.99 NO
1.27 YES
YES
YES
YES
YES

 

[Danny]

Try this: Copy formula in Column B.

=IF(ISBLANK(B1),"",IF(S131*(L131-L132)>0,"NO","YES"))

 

[Omer]

That didn't work, thanks for trying though . Any other
thoughts

See data

1.24 YES
-0.01 NO
0.49 YES
0.26 YES
1.27 YES
YES
YES
YES

 

[Omer]

Could it be because cells in Column A are connected to
another worksheet in the same file.

I mean A1 = F33 in Sheet 5

Or could it be that I have conditional formatting on where
if a cell is +ve number its Green, if a cell is -ve number
its Red.

Thanks
omer

 

[Danny]

If there is formula in A1, try this:

IF(A1=0,"",IF(S131*(L131-L132)>0,"NO","YES"))

 

[Danny]

Of course it matters because cell A1 has a formula and the
formula I gave you is ,"if A1 (I put B1, mistake) is
blank", then B1 should be blank. If A1 has a formula, then
A1 is not blank. So, try the other formula I gave you:
IF(A1=0,"",IF(S131*(L131-L132)>0,"NO","YES"))