IF/AND function to calculate remaining balance

[thakur80]

I am working on building a Vacation tracker and I am trying to create a formula that depending on the name of employee and the vacation code counts the number of hours used and provides the remaining balance from the alloted balance. This is the function I am using but it is returning the #N/A error

=IF(AND(Vacations[[#All],[Employee Name]]=M31:M34,Vacations[[#All],[Vacation Code]]=2),N30-Vacations['# of days taken]*8,FALSE)

Can someone please help with this?

[GC Excel]

Hello and welcome to the forum,

Difficult to test and answer without seeing your actual data but I would say that this part is incorrect

Please Login or Register  to view this content.

Please provide sample workbook if possible.

[thakur80]

Tracker.xlsx

I have attached the worksheet. Thanks!

[GC Excel]

Hello,

See the cells in yellow.
One column for the Balance at the beginning of the period,
One to calculate the number vacations hours taken,
One to calculate the remaining number of hours...

Tracker.xlsx

[thakur80]

Thank you!