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.

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Kevin" wrote:
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.

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