View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Liz Liz is offline
external usenet poster
 
Posts: 133
Default How to use the conditions? - Liz

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