Something like this:
=IF(B7*C18<0.5,TEXT(B7*C18*454,"0.00")&" GRAMS",TEXT(B7*C18,"0.00")&" LBS")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"g" wrote:
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