excel formula

By rph_herrera ·
To thumbsup2, thank you very much for your time and effort. God bless...
We are a employee of one company here. We want a cash advance of 5 thousand pesos and it is to be deducted to our leave credits. The problem is how cwn we compute a exact number of days to be deducted in our leave credits. Here are some information:

In column a are a list of names. In column B are list of salary which are given, in column C have a constant factor of 0.4715 which is also given, in column D have a given value of 5 thousand pesos. In column E are number of days to be solve for a 5 thousand pesos value. Thank you very much for your help. God bless

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Would this work?

by ThumbsUp2 In reply to excel formula

I have no idea what "monetization" means, but I'll take a stab at a formula for you. Would this work?


That takes the salary times the constant (exchange rate?), divides that number by 5000 (determines how many days are to be added?), then adds the result to the existing # of days/leave.

If this isn't the correct mathmatical formula for "monetization", then please explain further. Sorry, I have a tough time balancing my checkbook. Economics is way over my head.

Related Discussions

Related Forums