Referencing Negative Value

[Zedrick13]

Hi, guys. I can't seem to get the last if statement right. Please help! How do I reference negative value as a part of the if statement? Here's the formula I am working on:

=IF(AR4<=5,"<=5 days",IF(AR4<=10,"6-10 days",IF(AR4>10,">10 days",IF(AR4<=0,"Post-factum"))))

 

[Trebor76]

Hi Zedrick13,

Here's one way:

=IF(AND(AR4>=1,AR4<=5),"<=5 days",IF(AND(AR4>=6,AR4<=10),"6-10 days",IF(AR4>10,">10 days",IF(AR4<=0,"Post-factum"))))

Hope that helps,

Robert

 

[Yongle]

how about

=IF(AR4<=0,"Post-factum",IF(AR4<=5,"<=5 days",IF(AR4<=10,"6-10 days",">10 days")))