Thread: Need formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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