View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
siweltj siweltj is offline
external usenet poster
 
Posts: 1
Default 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.