View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
jmac2006 jmac2006 is offline
external usenet poster
 
Posts: 1
Default Restraints on an "if" statement

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