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 | |
|
|