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
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