IF(OR(

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

Sean NWIC

Here is my Formula, but it's not excepting:
[ IF(OR(G21>="2009-10",C21="Tuition Full Time Non-Tribal"),2718,2394) ]
IF I take this out, everything works. Can you Help Me?

=IF(OR(C21="Tuition Part Time Tribal",C21="Tuition Part Time
Non-Tribal"),H21*B21,IF(OR(G21>="2009-10",C21="Tuition Full Time
Tribal"),1002,882,IF(OR(G21>="2009-10",C21="Tuition Full Time
Non-Tribal"),2718,2394))
 
What does G21 contain? Is it a date? You can't compare that directly
with the string "2009-10" as you are trying to do.

Can you explain in words what you are trying to compare?

Pete
 
So here it is:
C21 is a drop down list of:
Tuition Full Time Tribal
Tuition Full Time Non-Tribal
Tuition Part Time Tribal
Tuition Part Time Non-Tribal

each of these have different Rates

Before (SUM) summer quarter of ("2009-10") the rate per credit for :
Tribal=PT:73.5, FT:882
Non-Tribal=PT:199.5, FT:2394

2009-10 on:
Tribal=PT:83.5,FT:1002
Non-Tribal=PT:226.5,FT:2718
Full time is 12-18 credits, every credit after 18 = addition single credit
rater per credit.



Pete_UK said:
What does G21 contain? Is it a date? You can't compare that directly
with the string "2009-10" as you are trying to do.

Can you explain in words what you are trying to compare?

Pete

Here is my Formula, but it's not excepting:
[ IF(OR(G21>="2009-10",C21="Tuition Full Time Non-Tribal"),2718,2394) ]
IF I take this out, everything works. Can you Help Me?

=IF(OR(C21="Tuition Part Time Tribal",C21="Tuition Part Time
Non-Tribal"),H21*B21,IF(OR(G21>="2009-10",C21="Tuition Full Time
Tribal"),1002,882,IF(OR(G21>="2009-10",C21="Tuition Full Time
Non-Tribal"),2718,2394))
Click to expand...
Click to expand...
 
Hi,

It's not accepting it because there is faulty logic in the IF statements -
of course it's not clear what the result should be but

=IF(OR(C21="Tuition Part Time Tribal",C21="Tuition Part Time
Non-Tribal"),H21*B21,IF(OR(G21>="2009-10",C21="Tuition Full Time
Tribal"),1002,882),IF(OR(G21>="2009-10",C21="Tuition Full Time
Non-Tribal"),2718,2394))

First if C21 ="Tuition Part Time Tribal" then H21*B21. Therefore the
second IF statement never is true!

Second, if the second IF statement is true then 1002 and if it is false 882,
therefore the third IF statement would never get tested.

Third, if C21 = Tuition Full Time
Non-Tribal", in the first OR then the last if would never be applicable.
 
Back
Top