View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
denise denise is offline
external usenet poster
 
Posts: 112
Default Novice formula question

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!!