B
Beth Ann
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 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!