If Formula

M

Matt

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
 
F

FSt1

hi
try this....
assuming E5 is 25 and J5 is the comparison. if 25 then ok???
=IF(J5<E5,"Underweight",IF(J5>E5,"overweight","ok"))

regards
FSt1
 
M

Matt

I am using this as a weight check If I am over by 26 pounds can I have it say
OK but if it over by 26 pounds I need it to say Overweight. and the same goes
if it is under 25 pounds it should be OK but if it is under 25 pounds it
should be Underweight. Is this possable?
 
Top