Excel - Assistance with if functions summing up in a common cell.

I am trying to make a cell display a value dependent upon the value of another cell. e.g. If cell A1 contains "1st" i want cell b2 to calculate that as the number 25. Easy enough, but the trick is i want to also have Cell b2 calculate as 17 if i input the value 2nd into cell A1 and so forth. So far this is the formula i am using =SUM(IF(N40="1st",25)&SUM(IF(N40="2nd",18))) but the cell displays as 250, rather than 25.

Then i want b2 to accumulate a series of cells with the same formula.

- - , .
.

Recent Questions...