Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF(OR(
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)) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF(OR(
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 On Sep 4, 5:21*pm, Sean NWIC wrote: 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)) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF(OR(
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" wrote: 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 On Sep 4, 5:21 pm, Sean NWIC wrote: 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)) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF(OR(
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. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Sean NWIC" wrote: 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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|