IF Function and a formula
Try something like this:
=MAX(your_formula,0)
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Fred Atkinson" wrote:
I need to use the IF function to prevent a value from dropping
below zero. What I've tried with Excel doesn't seem to work for me.
I'll represent the formula by <FORMULA. What I am trying to
do is illustrated by:
IF <FORMULA gt 0 then cell=<FORMULA
IF <FORMULA eq 0 then cell=0
IF <FORMULA lt 0 then cell=0
All of this should take place within the same cell and yield a
value. If this is done right, the value displayed in the cell should
never be less than zero.
Regards,
Fred
|