2 formulas 1 cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I use 2 formulas in 1 cell
I want to add Column G but do not want it to show if it is a negative
number.
I am using =SUM($G$4:G5)-50 then IF(M5<0,0,M5) so in column M I have entered
=SUM($G$4:G5)-50+IF(M5<0,0,M5) but even if it is a positive number it says 0.
 
How do I use 2 formulas in 1 cell
I want to add Column G but do not want it to show if it is a negative
number.
I am using =SUM($G$4:G5)-50 then IF(M5<0,0,M5) so in column M I have
entered
=SUM($G$4:G5)-50+IF(M5<0,0,M5) but even if it is a positive number it
says 0.
Click to expand...

Does this do what you want?

=MAX(SUM($G$4:G5)-50,0)

Rick
 
Another thought, you could try in a cell, copied down:
=IF(SUM($G$4:G5)-50<=0,"",SUM($G$4:G5)-50)
Above will return blanks: "" unless it's greater than zero
 
Hello,

Do you need to calculate your format or would it be sufficient to
"hide" negative numbers?

In this case you could apply the custom number format
#,##0;""
for example.

Regards,
Bernd
 
Back
Top