View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sean NWIC[_2_] Sean NWIC[_2_] is offline
external usenet poster
 
Posts: 11
Default Tuition Costs Again

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!