If then formula

[g]

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".)

 

[Fred Smith]

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