Stuck on IF Statement HELP!!

  • Thread starter Thread starter Omer
  • Start date Start date
O

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
 
"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"))
 
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.
 
Back
Top