COUNTIF Formula

guitarman

New member
Joined
Jul 8, 2015
Messages
2
Reaction score
0
Points
0
I am having a problem with this formula for a simple task. I wish to display a formula that can be used to determine prize money for golf tournaments.I.E
6 gold medal wins =£500 5 gold medal wins and 1 silver =£400 and 5 gold medals =£300 4 gold medals and 1 silver =£200. but i cannot get it to differeniate between 6 golds and 5 gold and 1 silver the same with 5 and 4+1 the formula I have is =COUNTIF(V3,"6")*500 and =COUNTIF(V3,"5"+1)*400 etc etc. So is it possible someone can tell me where I am going wrong.
Guitarman
 
Hi,
Assume Gold medal is in cell A2, Silver Medal cell is B2, Prize Money cell is C2. Try below formula.

=IF(AND(A2=6,B2=0),500,IF(AND(A2=5,B2=1),400,IF(AND(A2=5,B2=0),300,IF(AND(A2=4,B2=1),200,0))))
 

Attachments

  • Test.xlsx
    8.6 KB · Views: 6
Hi Sambit
Many thanks for that just the ticket May you have a great day and a brilliant life
Kind regards
Mike
 
Back
Top