Thread: If Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default If Formula

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