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

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

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

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

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

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