Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|