View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default 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