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
|