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