Thanks I have it working now!

"Andy_N1708 via OfficeKB.com" wrote:

Try this

=IF(A125,"Overweight",IF(A1=25,"OK","Underweight" ))

Matt wrote:
I have the following formula and I would like to have a 25 pound diffenence
as ok
=IF(J5<E5,"Underweight","ok") and anything under the 25 would be underweight
and any thing over the 25 pounds would be overweight is it possiable to add
this to the formula?

Thanks matt

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200905/1