Combining 3 IF functions

**Attrition** · 05-23-2013, 10:53 PM

Working on an assignment for school and I've mapped out each of the scenarios however, I have to use the IF and AND function to combine them and I'm not quite sure how. Also, it keeps saying use Nested Functions but Im pretty sure I have haven't I?

Can someone help me combine these please?

=IF(E8="sports",$B$4,IF(E8="compact",$B$3))

=IF(AND(B8<$F$2,C8="N"),$F$3,0)

=IF(D8="OK",F$4,0)

I've tried going =IF(AND(E8="sports",$B$4,IF(E8="compact",$B$3)),AND(IF(AND(B8<$F$2,C8="N"),$F$3,0),AND(IF(D8="OK",F$4,0)))

and it just says FALSE which is impossible because its supposed to calculate a payment.

Thanks

A

**nemo74** · 05-23-2013, 11:11 PM

Without being able to see the data here:

Please Login or Register  to view this content.

**Attrition** · 05-23-2013, 11:14 PM

Thanks Nemo!

And then I could just use a range function for E8:E50 to do the rest? Then just copy the function down?

**Attrition** · 05-23-2013, 11:17 PM

Like that formula would work for the Row of 8 but how would I use it for Row 9 +?

**nemo74** · 05-23-2013, 11:21 PM

with out seeing the data, I would say you can just drag it down.

**Attrition** · 05-23-2013, 11:26 PM

Q1.xlsx

Hopefully this will help. I just keep getting an error

Originally Posted by nemo74

with out seeing the data, I would say you can just drag it down.

**FDibbins** · 05-24-2013, 12:33 AM

Hi and welcome to the forum

Noway can you "nest" those formulas, each 1 is a separate, and each is independent of the others.
1. =IF(E8="sports",$B$4,IF(E8="compact",$B$3)) this works out a base insurance cost
2. =IF(AND(B8<$F$2,C8="N"),$F$3,0) this applies (or not) a premium to (1)
3. =IF(D8="OK",F$4,0) This is a discount that gets applied to (1) if certain criteria are met

So, you cannot "nest" them, 2&3 are applied to 1

because you only have 2 options (sports and compact), (1) can be shortened to =IF(E8="sports",$B$4,$B$3)

Also, because this is a homework assignment, because of forum rules, members cannot "give" you the answers, we can only guide you in the right direction, sorry.

edit: Just noticed this is (was) in the outlook forum, I will move it to the excel forum