1st,2nd OR3rd EQUALS $10,$15 OR $25

[Guest]

Office XL 2003

I have a column showing possitions 1st to 10th and I want this to
automaticaly enter $25 for 1st, $15 for 2nd and $10 for 3rd and 0 for all
the others into the column next to it. It is a database to keep track of how
I am doing in different poker rooms.

Thanx

 

[Paul B]

cold as ice, here is one way,

=IF(A1="1st",25,IF(A1="2nd",15,IF(A1="3rd",10,0)))

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Sandy Mann]

Try:

=IF(A1="1st",25,IF(A1="2nd",15,IF(A1="3rd",10,0)))

--
HTH

Sandy
In Perth, the ancient capital of Scotland

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Guest]

or...another possibility....

For a rank in A1 (1st, 2nd, 3rd, 4th, etc)

B1:
=IF(SUM(COUNTIF(A1,{"1st","2nd","3rd"})),LOOKUP(A1,{"1st","2nd","3rd"},{25,15,10}),0)


***********
Regards,
Ron

XL2002, WinXP

 

[Guest]

Thank you so much for the reply, this was a great help to me and with a bit
of tweaking it did the job a treat.

This is how i eventualy sorted it out

=IF(A1=3,10,IF(A1=2,15,IF(A1=1,25,0)))

Thank you again

Clem

 

[Paul B]

Your welcome


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003