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

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.

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.

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.