Need function & formula

[mikesal57]

Hi All..

Say I have a number in A1 ...

Say in A20 I need to do this:

if a1=1 enter 100 as answer...if a1=2 enter 62 as answer....if a1=3 then enter 38 as answer....if a1=4 then enter 24 as answer.......any other number enter o(zero)

Thxs

Mike

 

[AhoyNC]

If the numbers in A1 will always be positive try:
=LOOKUP(A1,{1,2,3,4,5},{100,62,38,24,0})

If there could be negative numbers in A1 then try:
=LOOKUP(A1,{-9.99999999999999E+307,1,2,3,4,5},{0,100,62,38,24,0})

 

[mikesal57]

Awesome Ahoy..thxs so much

Mike

 

[AhoyNC]

You're welcome. Thanks for the feedback.

 

[Jonmo1]

Also perhaps
=IFERROR(CHOOSE(A1,100,62,38,24),0)