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/181958-re-if-then-formula.html)

Max

If then formula

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

All times are GMT +1. The time now is 10:34 PM.