Tuition Costs Again

[Sean NWIC]

Sorry But this popped up. Can I shortcut this at all? Here's the problem. I
can only show 7 equations in a cell. Can you show me how I can add
[,IF(AND(C21="Tuition Part Time Tribal",G21<{2009-10}),73.5]?

Maybe there is a way for C21 to = "Tuition Full Time Non-Tribal" (AND)
"Tuition Part Time Tribal" to be in the same equation?

=IF(AND(C21="Tuition Full Time
Non-Tribal",G21>={"2009-10"}),226.5,IF(AND(C21="Tuition Part Time
Non-Tribal",G21>={"2009-10"}),226.5,IF(AND(C21="Tuition Full Time
Tribal",G21>={"2009-10"}),83.5,IF(AND(C21="Tuition Part Time
Tribal",G21>={"2009-10"}),83.5,IF(AND(C21="Tuition Full Time
Non-Tribal",G21<{"2009-10"}),199.5,IF(AND(C21="Tuition Part Time
Non-Tribal",G21<{"2009-10"}),199.5,IF(AND(C21="Tuition Full Time
Tribal",G21<{"2009-10"}),73.5)))))))

Thanks for the previous help!!!
It was GREAT!

 

[Luke M]

What happens if your conditions are not met? If you're sure that C21 will be
one of the four choices, you can simplify formula down to:

=IF(G21>="2009-10",
IF(OR(C21="Tuition Full Time Non-Tribal",C21="Tuition Part Time
Non-Tribal"),226.5,83.5),
IF(OR(C21="Tuition Full Time Non-Tribal",C21="Tuition Part Time
Non-Tribal"),199.5,73.5))

else

=IF(G21>="2009-10",
IF(OR(C21="Tuition Full Time Non-Tribal",C21="Tuition Part Time
Non-Tribal"),226.5,IF(OR(C21="Tuition Full Time Tribal",C21="Tuition Part
Time Tribal"),83.5,"Criteria not met")),
IF(OR(C21="Tuition Full Time Non-Tribal",C21="Tuition Part Time
Non-Tribal"),199.5,IF(OR(C21="Tuition Full Time Tribal",C21="Tuition Part
Time Tribal"),73.5,"Criteria not met")))

Note that even this last formula only has 4 nested functions at max (the
trick is using all the different IF branches).

 

[Sean NWIC]

Now I need something else!!!

I need the total to be effected by the date as well.
I need Tuition for:
(NON-TRIBAL FT=2718)AFTER 2009-10
(NON-TRIBAL FT=2394)BEFORE 2009-10
(TRIBAL FT=1002)AFTER
(TRIBAL FT=882)BEFORE
NON-TRIBAL PT = H21*B21
TRIBAL PT= H21*B21

What happens if your conditions are not met? If you're sure that C21 will be
one of the four choices, you can simplify formula down to:

=IF(G21>="2009-10",
IF(OR(C21="Tuition Full Time Non-Tribal",C21="Tuition Part Time
Non-Tribal"),226.5,83.5),
IF(OR(C21="Tuition Full Time Non-Tribal",C21="Tuition Part Time
Non-Tribal"),199.5,73.5))

else

=IF(G21>="2009-10",
IF(OR(C21="Tuition Full Time Non-Tribal",C21="Tuition Part Time
Non-Tribal"),226.5,IF(OR(C21="Tuition Full Time Tribal",C21="Tuition Part
Time Tribal"),83.5,"Criteria not met")),
IF(OR(C21="Tuition Full Time Non-Tribal",C21="Tuition Part Time
Non-Tribal"),199.5,IF(OR(C21="Tuition Full Time Tribal",C21="Tuition Part
Time Tribal"),73.5,"Criteria not met")))

Note that even this last formula only has 4 nested functions at max (the
trick is using all the different IF branches).
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

Sorry But this popped up. Can I shortcut this at all? Here's the problem. I
can only show 7 equations in a cell. Can you show me how I can add
[,IF(AND(C21="Tuition Part Time Tribal",G21<{2009-10}),73.5]?

Maybe there is a way for C21 to = "Tuition Full Time Non-Tribal" (AND)
"Tuition Part Time Tribal" to be in the same equation?

=IF(AND(C21="Tuition Full Time
Non-Tribal",G21>={"2009-10"}),226.5,IF(AND(C21="Tuition Part Time
Non-Tribal",G21>={"2009-10"}),226.5,IF(AND(C21="Tuition Full Time
Tribal",G21>={"2009-10"}),83.5,IF(AND(C21="Tuition Part Time
Tribal",G21>={"2009-10"}),83.5,IF(AND(C21="Tuition Full Time
Non-Tribal",G21<{"2009-10"}),199.5,IF(AND(C21="Tuition Part Time
Non-Tribal",G21<{"2009-10"}),199.5,IF(AND(C21="Tuition Full Time
Tribal",G21<{"2009-10"}),73.5)))))))

Thanks for the previous help!!!
It was GREAT!