Need formula
Try:
=IF((SUM(F5:R5)-C5-D5+B5)<0,"",=SUM(F5:R5)-C5-D5+B5)
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Debsdad" wrote:
I have a spread sheet that calculates a range of cells but would like to have
it return blank if less than 0. The formula I have is =SUM(F5:R5)-C5-D5+B5,
what do I need to do?
Thank you
|