| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need formula
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need formula
Try
=IF((SUM(F5:R5)-C5-D5+B5) < 0, "",SUM(F5:R5)-C5-D5+B5) where you are using =SUM(F5:R5)-C5-D5+B5 "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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need formula
I Get a FALSE when this is applied
"Sheeloo" wrote: Try =IF((SUM(F5:R5)-C5-D5+B5) < 0, "",SUM(F5:R5)-C5-D5+B5) where you are using =SUM(F5:R5)-C5-D5+B5 "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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need formula
This did not return anything except an error.
"Shane Devenshire" wrote: 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need formula
I tested it again and got the expected answer..
Pl. paste the formula you are using. "Debsdad" wrote: I Get a FALSE when this is applied "Sheeloo" wrote: Try =IF((SUM(F5:R5)-C5-D5+B5) < 0, "",SUM(F5:R5)-C5-D5+B5) where you are using =SUM(F5:R5)-C5-D5+B5 "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
