Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change multiplier using letters
I am using Excel 2007
A1=8 B1, requires an input in letter form, such as "D" or "T" or it is left empty C1, would be the product of A1*2, if B1=D OR A1*1.5, if B1=T OR C1 would be 8 if B1 were left empty |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change multiplier using letters
=A1*LOOKUP(B1,{"D","T","";1.5,8,2})
"Pipeline welder" wrote: I am using Excel 2007 A1=8 B1, requires an input in letter form, such as "D" or "T" or it is left empty C1, would be the product of A1*2, if B1=D OR A1*1.5, if B1=T OR C1 would be 8 if B1 were left empty |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change multiplier using letters
Hi,
=IF(B1="D",A1*2,IF(B1="T",A1*1.5,"")) or =IF(B1="","",A1*IF(B1="D",2,1.5)) Should do it. Note you have not dealt with the possibility that B1 contains something else. -- Thanks, Shane Devenshire "Pipeline welder" wrote: I am using Excel 2007 A1=8 B1, requires an input in letter form, such as "D" or "T" or it is left empty C1, would be the product of A1*2, if B1=D OR A1*1.5, if B1=T OR C1 would be 8 if B1 were left empty |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiplier | New Users to Excel | |||
how to change small letters to capital letters | Excel Discussion (Misc queries) | |||
How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
change lower letters to upper letters | Excel Discussion (Misc queries) | |||
Use a multiplier to change List Prices to Net prices | Excel Worksheet Functions |