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
Bookmarks