Hi,
I have a formula in a cell that checks a cell value in a table in the State field (in this case the value is ACT). I then do a calculation counting the business days and including public holidays listed in another table under the field with a name that matches the state (ACT). Is there a way to include the cell value of ACT within the formula so I don't have to do nested IFs testing for all valid states?
Formula:Please Login or Register to view this content.
Thanks
Bookmarks