Restraints on an "if" statement
 

Something like this in say, C1:
=IF(A1="","",IF(MAX(A1,0)B1,"C","D"))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"jmac2006" wrote:
Hi there,

I have a simple "if" statement and am trying to add a constraint.
Essentially, the statement is:

If(AB, C, D)

However, I wan to say if "A" is a negative number, then it should be 0
(can't have a negative number).

Anyone have any advice?

Thanks