Selection based result formula

  • Thread starter Thread starter Dave Peterson
  • Start date Start date
D

Dave Peterson

See one reply at your other post.
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.
Click to expand...
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Copying a formula to a range 2
Excel Subtracting multiple columns from another column 3
Put Formula in VBA 1
VBA to run all variable combinations in a calculation model and store result 6
Array formula with =sum 2
VBA for data validation in 3rd column does not run. I need help. 1
Check a 'Logsheet' for a match, before continuing a sub 3

Back
Top