Tuition Costs Again

  • Thread starter Thread starter Sean NWIC
  • Start date Start date
S

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!
 
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).
 
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


Luke M said:
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!*


Sean NWIC said:
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!
Click to expand...
Click to expand...
 
Back
Top