Question

Locked

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.

2 total posts (Page 1 of 1)  
| 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?

=((B1*C1)/E1)+D1

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.

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums