Formula Help

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

I have this formula in a cell AB19:

=IF(AA19<0,"",IF(O20>0,P20,IF(L20>0,M20)))

If cell AA19 is empty I want cell AB19 to be empty. The probem is
that in cell AA19 there is a return of false, which I have
conditionally formattted to not show up.

I've tried less than 0, if AA19="","", and everything else I could
think of.

How can I make cell AB19 not return a value when AA19 returns false?
 
It really returns False?

=IF(OR(AA19=FALSE,AA19<0),"",IF(O20>0,P20,IF(L20>0,M20)))
or
=IF(AA19=FALSE,"",IF(O20>0,P20,IF(L20>0,M20)))
 
No, it doesn't return false, but it does return the value from another
cell because the cell next door is false. I don't want it to return
anything.

Re your formula =if(aaq9=FALSE,"")...this works. I was doing:

=if(aa19="false",""), and I also tried =if(aa19,"false"="") and
=if(aa19,false,""). I see my error now.

Thank you.
 
Back
Top