=IF(A2="adult",B2,IF(A2="child",C2,IF(A2="grandpa" ,D2,E2)))

But much better would be to use the VLOOKUP() function.

See this nice introduction:

http://www.contextures.com/xlFunctions02.html

--
Kind regards,

Niek Otten

"Hickeym" wrote in message ...
| Hello,
| I am attempting to do a calculation in Excel and I am not sure how to
| proceed. The idea is the following:
|
| if cell A2 equals a specific word (text), like "Adult", then I want it to
| grab cell B2 which is a % and put it into cell A3. However, there can be up
| to four "words" and depending on which word is in the cell, it needs to grab
| a different cell with a different % in it and put THAT into another cell.
|
| For example - A2 equals "Adult", cell B2 equals 100%, I want cell A3 to
| equal 100%.
| Cell B2 needs to be able to be change to any %...
|
| The final cell is then a part of another formula.
|
| Thanks