little rusty with IF

  • Thread starter Thread starter ken
  • Start date Start date
K

ken

im making a payout sheet fo nascar pool (hate nascar but was asked do
do as a favor) its been awhile since ive used excel ok here my
question



i want to compare number A(qualifying position) with the results of the
qualifying round and then the end of race by car number for instance


i drew the pole position qualifing position 1
the car number that qualified in that position was car number 8
(earnhart)

at the end of the race car number 8 came in 1st place so i get the
payout of 25 DOLLARS

but if car number 8 came in 2nd place i only get 10 dollars and so on
untill 5th place

all i can remember is the IF function but that only compares 2 cells


am i making anyu sense at all, i od'd on my meds and am feeling
confused lol
 
As an old Sports Car racer (Formula Ford), I sympathize.
Try using the CHOOSE function. Look in HELP index.
 
=IF(A1="1st place",25,IF(A1="2nd place",10,IF(A1="3rd place",7,IF(A1="4th
Place",5,IF(A1="5th place",3,"")))))

Vaya con Dios,
Chuck, CABGx3
 
Back
Top