Multiple conditions for one function
 

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.

Multiple conditions for one function
 

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)

"Minnie2627" wrote in message
...
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.

Multiple conditions for one function
 

Hi,

Following should help ...

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

HTH

Multiple conditions for one function
 

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

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



"Minnie2627" escreveu:

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.

Multiple conditions for one function
 

=IF(AND(A2<"",A2=0),"whatever you want","")
--
David Biddulph

"Minnie2627" wrote in message
...
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.

Multiple conditions for one function
 

And how does that treat a blank cell, Marcelo?
--
David Biddulph

"Marcelo" wrote in message
...
=if(a1=0;function;"")

hth

"Minnie2627" escreveu:

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.

Multiple conditions for one function
 

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:

And how does that treat a blank cell, Marcelo?
--
David Biddulph

"Marcelo" wrote in message
...
=if(a1=0;function;"")

hth

"Minnie2627" escreveu:

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.