Not quite my bedtime yet ...

I would suggest:

=IF(C22-C24=0,"No Change",ABS(C22-C24)&" Lb"&IF(ABS(C22-
C24)1,"s","")&IF(C22-C240," Lost"," Gained"))

Pete

On Nov 7, 12:27 am, "Sandy Mann" wrote:
Good point. Then how about:

=IF(C22-C24=0,"No Change",(ABS(C22-C24))&" "&IF(C22-C240,"Lbs Lost","Lbs
Gained"))

and:

=IF(C22-C24=0,"No Change",(ABS(C22-C24)&"
"&IF(C22-C240,"Lb"&IF(C22-C241,"s","")&"
Lost",IF(C22-C24<0,"Lb"&IF(C22-C24<-1,"s","")&" Gained"))))

Not exhaustively tested because it is past this old man's bedtime.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

"Pete_UK" wrote in message

ups.com...



Well, that seems to be dotting the i's and crossing the t's, Sandy
<bg, although you will get:

0 No Change

whereas I would have thought just:

No Change

would be better.

Pete

On Nov 6, 11:23 pm, "Sandy Mann" wrote:
Not so good. It returns negative figures try:

=ABS(C22-C24)&" "&IF(C22-C240,"Lbs Lost",IF(C22-C24<0,"Lbs Gained","No
Change"))

If you want to go further and have no s at the end of Lbs if the answer
is 1
then use:

=ABS(C22-C24)&" "&IF(C22-C240,"Lb"&IF(C22-C241,"s","")&"
Lost",IF(C22-C24<0,"Lb"&IF(C22-C24<-1,"s","")&" Gained","No Change"))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

"Denise" wrote in message

...

Thank you Sandy - that's exactly what I needed. Thanks to you too
Kevin,
I
always add a couple of skills when I "chat" with the "experts".

"Sandy Mann" wrote:

Assuming that C22 is the "Before" cell try:

=C22-C24&" "&IF(C22-C240,"Lbs Lost",IF(C22-C24<0,"Lbs Gained","No
Change"))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

"Sandy Mann" wrote in message
.. .
=IF(C26<0,"Lost",IF(C260,"Gained","Still the same"))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

"Denise" wrote in message
...
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!!- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -