Stuck on IF Statement HELP!!

[Omer]

I would like B colum to stay Blank until a value is
entered in Column A.


FYI: Cell A1 in "Sheet 1" is connected to Cell A2
in "Sheet 2". Also I have conditional formatting on Column
B such that when its a "YES" it is highlighted as RED and
when "NO" it is highlighted as Green.

Data is as follows:

A B

-0.99 NO
1.27 YES
YES

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 that Excell calculates B3 even when there
is no value in Column A. I would like B colum to
stay Blank until a value is entered in Column A.

Thanks for the help
Omer

 

[Laura Cook]

"Sheet 1" is connected to Cell A2 in "Sheet 2".

In what sense do you mean connected? By formula? What is the formula?

I believe there a missing parentheses in the formula you have posted.

Give the following a try:

=IF(A1="","",IF(S129*(L129-L130)>0,"NO","YES"))

 

[Danny]

Try this:

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

 

[Laura Cook]

When there is no value on sheet2, does it show up as zero ("0") on sheet1?
If so try the following:

=IF(A1=0,"",IF(S129*(L129-L130)>0,"NO","YES"))

If you are still having problems, you can go ahead and send me the file.