IF formula

[Nan]

How do I write a formula based on the value in 2 different cells? Fo
example, if A1=0 and B1>0 I want the result to say "Alert" otherwise
want to divide C1 by A1.

Thanks for any help

 

[Frank Kabel]

Hi
=IF(AND(A1=0,B1>0),"Alert",C1/A1)

 

[Nan]

Thank you

 

[Nan]

I realized that I also need to add another scenario. If A1=0 and B1=0
want the result to be 0. Since C1 is the difference between A1 and B1
and if they are both 0, I get an error message.

Can this be added to the formula below?

Thanks

 

[Frank Kabel]

Hi
try
=IF(AND(A1=0,B1>0),"Alert",IF(A1<>0,C1/A1,0))