Hi - I'm stuck!!
Here is my formula... in D12
=IF(S8<365,(D11/365)*S8,IF(B6="Location","",IF(B6="London",D11*7.2,IF(B6="National",D11*7.4)))))
So 'S8' calculates number of days between today and date inputed by user; if this is less than 365 the user's entitlement (D11) is divided by 365 then multiplied by the number of days in S8.
The result in D12, then needs to be multiplied either by 7.2, or 7.4 dependent on the final 2 arguments.
TIA
Here is my formula... in D12
=IF(S8<365,(D11/365)*S8,IF(B6="Location","",IF(B6="London",D11*7.2,IF(B6="National",D11*7.4)))))
So 'S8' calculates number of days between today and date inputed by user; if this is less than 365 the user's entitlement (D11) is divided by 365 then multiplied by the number of days in S8.
The result in D12, then needs to be multiplied either by 7.2, or 7.4 dependent on the final 2 arguments.
TIA