Forum Discussion
Solved
If and function in excel for a newbie
Hi,
I am trying to use if and to to create a table for my homework but keep getting my formula wrong.
It's a simple table
| Premiums | ||
| Cat | Dog | |
| Plan A | 22.5 | 37.5 |
| Plan B | 35.5 | 52.5 |
| Plan C | 45 | 65 |
| Plan D | 52 | 75 |
and I want to be able to select if Plan A and type of pet are selected the correct fee is shown
eg Plan A for a cat would be 22.5 and for a dog 37.5
can someone please show me the correct formula for this?
See the attached demo workbook.
2 Replies
brilliant, thank you for your help
See the attached demo workbook.
