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

Hi,

=IF(J5<E5,"Underweight",IF(J5E5,"Overweight","ok" ))

"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

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

regards
FSt1

"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

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

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?

"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

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