ExcelBanter - If then formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If then formula (https://www.excelbanter.com/excel-worksheet-functions/181961-if-then-formula.html)

If then formula

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

Fred Smith[_4_]

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

All times are GMT +1. The time now is 05:48 PM.