| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selection based result formula
See one reply at your other post.
siweltj wrote: I need a formula that will display one thing in column "B" based on the entry in column "A". There would be 20 different possibilities depending on the entry in column "A" Example: If "15" is entered in column "A" then "Staff Wages" would appear in column "B"; if "18" was entered in column "A" then "Production Wages" would appear in column "B" Hope someone can help. -- Dave Peterson |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selection based result formula
I need a formula that will display one thing in column "B" based on the
entry in column "A". There would be 20 different possibilities depending on the entry in column "A" Example: If "15" is entered in column "A" then "Staff Wages" would appear in column "B"; if "18" was entered in column "A" then "Production Wages" would appear in column "B" Hope someone can help. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selection based result formula
te
"siweltj" wrote in message news:9mGad.17618$Lo6.10657@fed1read03... I need a formula that will display one thing in column "B" based on the entry in column "A". There would be 20 different possibilities depending on the entry in column "A" Example: If "15" is entered in column "A" then "Staff Wages" would appear in column "B"; if "18" was entered in column "A" then "Production Wages" would appear in column "B" Hope someone can help. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selection based result formula
I would use a select case formula...
Regards S "siweltj" wrote in message news:9mGad.17618$Lo6.10657@fed1read03... I need a formula that will display one thing in column "B" based on the entry in column "A". There would be 20 different possibilities depending on the entry in column "A" Example: If "15" is entered in column "A" then "Staff Wages" would appear in column "B"; if "18" was entered in column "A" then "Production Wages" would appear in column "B" Hope someone can help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying a result based on user selection | Excel Discussion (Misc queries) | |||
| Formula result based on Multiple IFs | Excel Worksheet Functions | |||
| VLOOKUP based on a formula result | Excel Worksheet Functions | |||
| lock cells based on formula result | Excel Discussion (Misc queries) | |||
| Formula to populate a drop down list based on the selection of ano | Excel Discussion (Misc queries) | |||
![Dave Peterson[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
