Forum Discussion
Excel IF AND help needed.
I have the following acceptable values in my spreadsheet:
| Answer:PlanSelect | Answer:PetType | SetFee:BasePremium |
| Plan A | Cat | 22.5 |
| Plan B | Cat | 35.5 |
| Plan C | Cat | 45 |
| Plan D | Cat | 52 |
| Plan A | Dog | 37.5 |
| Plan B | Dog | 52.5 |
| Plan C | Dog | 65 |
| Plan D | Dog | 75 |
and I need to use function IF AND so that only one option appears if selected but I seem to keep messing up what should be a fairly simple function command.
| Premiums | ||
| Cat | Dog | |
| Plan A | 22.5 | 37.5 |
| Plan B | 35.5 | 52.5 |
| Plan C | 45 | 65 |
| Plan D | 52 | 75 |
Any ideas on what it should be?
3 Replies
Isn't this the same, or almost the same, as If and function in excel for a newbie | Microsoft Community Hub
Hi HansVogelaar,
It's not quite the same, slightly different,
Regards
It's not clear to me what is given and what should be calculated.
