Multiple Variable Formula Help
 

Hi, I need help creating a formula that will give a different result based on
multiple variables... The formula I created below is not correct, but will
give you an idea of what I'm trying to accomplish...

=IF((B2=2007,"Ordered in Current Year"),ORIF((B2<2007)AND(C2=2007),"Paid
Current Year from Prior Year Order),ORIF(B2<2007)AND(C2="
"),"StillOpenFromAPriorMonth"))

Inv.No. Inv.YR. Paid Year Status
1224 2006 2007 Closed
1225 2006 Open
1226 2007 2007 Closed
1227 2007 Pending

Thank you!

Multiple Variable Formula Help
 

Beth Ann -- You're not too far. I haven't tested this, but:

=IF(B2=2007,"Ordered in Current Year",IF(AND(B2<2007,C2=2007),"Paid Current
Year from Prior Year's Order","Still Open From a Prior Month"))

Something pretty close to that should work.

HTH.

"Beth Ann" wrote:

Hi, I need help creating a formula that will give a different result based on
multiple variables... The formula I created below is not correct, but will
give you an idea of what I'm trying to accomplish...

=IF((B2=2007,"Ordered in Current Year"),ORIF((B2<2007)AND(C2=2007),"Paid
Current Year from Prior Year Order),ORIF(B2<2007)AND(C2="
"),"StillOpenFromAPriorMonth"))

Inv.No. Inv.YR. Paid Year Status
1224 2006 2007 Closed
1225 2006 Open
1226 2007 2007 Closed
1227 2007 Pending

Thank you!

Multiple Variable Formula Help
 

That did it, THANK YOU!!! ~~Beth Ann

"pdberger" wrote:

Beth Ann -- You're not too far. I haven't tested this, but:

=IF(B2=2007,"Ordered in Current Year",IF(AND(B2<2007,C2=2007),"Paid Current
Year from Prior Year's Order","Still Open From a Prior Month"))

Something pretty close to that should work.

HTH.

"Beth Ann" wrote:

Hi, I need help creating a formula that will give a different result based on
multiple variables... The formula I created below is not correct, but will
give you an idea of what I'm trying to accomplish...

=IF((B2=2007,"Ordered in Current Year"),ORIF((B2<2007)AND(C2=2007),"Paid
Current Year from Prior Year Order),ORIF(B2<2007)AND(C2="
"),"StillOpenFromAPriorMonth"))

Inv.No. Inv.YR. Paid Year Status
1224 2006 2007 Closed
1225 2006 Open
1226 2007 2007 Closed
1227 2007 Pending

Thank you!

Multiple Variable Formula Help
 

PD, that did it... THANK YOU!!! ~~Beth Ann

"Beth Ann" wrote:

Hi, I need help creating a formula that will give a different result based on
multiple variables... The formula I created below is not correct, but will
give you an idea of what I'm trying to accomplish...

=IF((B2=2007,"Ordered in Current Year"),ORIF((B2<2007)AND(C2=2007),"Paid
Current Year from Prior Year Order),ORIF(B2<2007)AND(C2="
"),"StillOpenFromAPriorMonth"))

Inv.No. Inv.YR. Paid Year Status
1224 2006 2007 Closed
1225 2006 Open
1226 2007 2007 Closed
1227 2007 Pending

Thank you!