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.