Writng a SUMIF statement with text
Posted by Shane Evans on October 09, 2000 10:14 AM
I am wanting a cell to type "Under" if the previous cells' value is less than 0, and "Over" if the previous cells' value is greater than zero.
Thank You
Posted by Celia on October 09, 2000 10:32 AM
Thank You
Shane
I've assumed that you want to compare the sum of a range of cells with 0. And also to show 0 if the value is 0 :-
=IF(SUM(your range)<0,"Under",if(SUM(your Range)>0,"Over",0))
Celia
