Nested If Function

[Petsi]

Is there a way to make F8 a nested IF function instead of what I have?

[MarvinP]

Hi Petsi,

I like what you have now. To nest the if statement you would need something that triggered if you had NO. Your formulas look fine to me. What if you added two columns after the Locker and Spa fee that would show zero if they were no. Would that make you happier?

Another method might be a lookup table for all the members by name and have a Yes or No table, on its own, for just Locker and Spa.

[nimrod]

Nested ifs indicate a relationship between the items ... in your situation there is no dependency between locker fees and spa passes . So I don't see them being nested if's.

[Petsi]

Thank you, you two! I didn't think so, but this is for an assignment and it's telling me to use a nested IF and I can't figure out how without confusing myself and trying to use AND/OR and still getting an error or not counting both when the first is "No."

I am going to keep it like that and see how it goes. I will at least get part marks right?

[nimrod]

The only way a nested if makes sense is if the Locker Fee and Spa Fee are not independent of one another. For example if you have a Spa Fee then the Locker Fee is not charged then nesting makes sense. Are you sure if both are marked yes then both are to be applied ??

... when your instructor gives you the answer he/she expected I'd love to see it posted.

[nimrod]

Here's your nested answer ... but your instructor is just wrong if they think this is a better solution than the original

=IF(OR(D8="Yes",E8="Yes"),IF(AND(D8="Yes",E8="Yes"),C31+C32,IF(D8="YES",C31,C32)),0) + C8