Try this formula:

=IF(C26=0,"",IF(C260,"Lost",IF(C26<0,"Gained")))

If C26 = 0 the cell displays nothing, if less than 0 "Gained" and if 0
"Lost"
--
Kevin Backmann


"Denise" wrote:

I'm creating a simple spreadsheet to track results BEFORE & AFTER for
students coming through a family fitness program.

Cell C26 is the difference between C22 & C24. If the SUM is greater than 0
is there a formula that could print the word LOST to the right of the sum?

Obviously I need the word GAINED if the sum is less than zero.

Thanks!!