IF Statement Issues

Hello,

Please can someone assist?

I need to create a formula that will remove "0.5" or "1" from a total, from cells that say "Half Day" or "Full Day" respectively. E.g. If the employee has 26 days holiday left and I enter "Full Day" into the relevant cell, I need it then to minus "1" from the total of holidays entitled, resulting in "25"

The cells with "Full Day" and "Half Day" in the have Data Validation applied and I don't know if that will affect the process?

There's probably a more coherent way of explaining that I apologise.

Any help would be greatly appreciated.

Andrew

Are you looking for something like the attached?

Yes that's great, thank you very much!

Will it still work if conditional formatting is applied?

Yes, conditional formatting shouldn't affect anything.

I've just tried to drag the formula down and it only works on the row below, after that the number is "0"

Also, I have seperated the months on to different tabs, but I need a the total holdiays to decrease over the year. Is this posible over 12 tabs? Or would it be more beneficial to have the entire year on one tab?

I really appreciate all your help

Plus I need the total to be "26" over the year?

Thanks again

Copy of Holiday Tracker HR WV2.xlsx

Here's the file

Hi dear

i have attached a book in column c you see a function and at end it takes a simple sum

regards