Forum Discussion
Need help with excel formula
Hi and thank you very much for your help and advice, and what can I say the HR is keen on this kind of data presentation (with name, type and amount, subtotal), I have seen the formulae and it surely helps to calculate the cost per employee the only issue is that if the cost of insurance changes as per age and medical condition the formula needs to be changed as well, is there any way to make it dynamic.
Thanks
Done for the rate info I have but not as per age and medical condition since you supplied no conditions and their effects.
But yes, a table that is used as the basis for the rates is very possible and the desirable way to do it, so you can change any given rate just once and have all the formulas automatically adjust because they're really using the table.
If you want to get more specific, you'd have to show us how age or medical conditions change things so we could incorporate those into a table.
Are you IN HR? Or are you IT support to HR? Your role in all this is unclear.