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

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

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

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

"cold as ice" wrote in message
...
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

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

Try:

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

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"cold as ice" wrote in message
...
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

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

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


"cold as ice" wrote:

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

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

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" wrote:

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

"cold as ice" wrote in message
...
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

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

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

"cold as ice" wrote in message
...
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" wrote:

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

"cold as ice" wrote in message
...
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