IF function with multiple criteria

[Horus73]

Hi,
How will the formula be in the following situation?

Cel A1- 3 options for input
Jean, Pete, Jim


C A2 - If function in which I want to combine three ifs
=IF(A1="jean";"+4 points";"")
=IF(A1="Pete";"+2 points";"")
=IF(A1="Jim";"+5 points";"")

Thus, CA2 should contain one IF formula. If Jim is entered in A1 then it will give +5 points, but if Pete is entered then it will show +2 points ...and so on.

Thanks again!
Marc

 

[IML]

Going down nimrod's school of thought, also
=IF(I2<=19,"0-19",IF(I2>64,">64",FLOOR(I2,5)&"-"&(FLOOR(I2,5)+4)))

 

[Nimrod]

Hi IML: Yours is my favourite solution... so far :wink:

 

[rrdonutz]

Originally posted by Nimrod
Hi IML: Yours is my favourite solution... so far :wink:

Yes, mine too, as it's an improvement on what I originally proposed (5 replies back):

=IF(I2>64,"65+",IF(I2<=19,"0-19",INT(I2/5)*5&"-"&INT(I2/5)*5+4))

 

[Katherine Mason]

My sincerest thanks to all of you for your assistance! I love this site, and plan to be a regular!