Thread: If then formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default If then formula

Yes, you can combine them, as in:

=IF(B7*c18<0.5,B7*C18*454&" GRAMS",B7*C18&" LBS")

If you want the number formatted in a specific way, use the Text function,
as in:

=IF(B7*c18<0.5,TEXT(B7*C18*454,"#,##0")&" GRAMS",TEXT(B7*C18,"#,##0")&"
LBS")

Regards,
Fred

"g" wrote in message
...
Trying to combine these formulas. Where the then statement would also
contain a specific data label. Is it possible? If so how?

1. =IF(B7*c18<0.5,B7*C18*454,B7*C18)
2. =IF(B7*c18<0.5,"GRAMS","LBS".)

--
G