How to use the conditions? - Liz

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need help with this if anyone can help me with this:

A1=$1500
B1=$1500

I want to create a logic that if B1 is greater or equal to A1 then YES and
if B1 is less than A1 then NO. And if the cells A1 or B1 is blank then the
result cell should also appear blank and should not show #Value? or other
values in the conditioned cell.

What should I should to get this conditioned in one cell?

Thanks
Liz
 
This formula should work:

=IF(OR(A1="",B1=""), "", IF(B1 >= A1, "YES", "NO"))

If A1 or B1 is blank, return a blank, otherwise if B1 is greater or equal
than A1 return Yes, otherwise return No.
 
It worked thanks. I've another question...........

If A1 = 2/17/2007
B1 = 2/22/2007

I've cell C1 with a formula to calculate the difference between those dates
and based on the result which appears on C1 I've a condition in cell D1 which
is if C1 is greater or equal to 0 then YES and if less than 0 then NO. But I
need one more condition that is if c1 is has no value which is when the A1
and B1 is blank I need the D1 cell to appear blank to but should have the
condition in place. PS: I've formatted the C column by unchecking the zero
values under Tools/Options/View.

Thanks
Liz
 
Back
Top