Multiple conditions for one function

[Minnie2627]

I want a function to occur when a value in one cell is greater than 0 and
when it equals zero. However when the cell is blank i do not want the
function to occur or for there to be anything visible in the cell. Right now
it is treating a blank cell as zero.

 

[Ron Coderre]

With
A1: (a number, zero, or blank)

Try this:
=IF(A1="","",IF(A1,"your <> zero formula","your = zero formula"))

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[Carim]

Hi,

Following should help ...

=IF(AND(A1>=0,A1<>""),"YES","")

HTH

 

[Marcelo]

=if(a1>=0;function;"")

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Minnie2627" escreveu:

 

[David Biddulph]

=IF(AND(A2<>"",A2>=0),"whatever you want","")

 

[David Biddulph]

And how does that treat a blank cell, Marcelo?

 

[Marcelo]

yes you are right, I lost some part of the question.

sorry for the mistake
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"David Biddulph" escreveu: