Put this formula in N2, it will populate the table.
=IF(Table2[[#This Row],[DIST_HS]]>=50,"Zone 2 (Complete Voucher)", IF(AND(Table2[[#This Row],[DIST_HS]]<50,Table2[[#This Row],[ADDY_CITY]]="San Antonio"),"Zone 1A (Local, No Voucher)", IF(AND(Table2[[#This Row],[DIST_HS]]<50,Table2[[#This Row],[ADDY_CITY]]<>"San Antonio"),"Zone 1B (Mileage Only, No Voucher)", "Other")))
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
I'll give this a try when I get to work in a bit. I also think I see what I was doing wrong...nesting incorrectly.
It worked! Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks