Software·43,883 discussions

excel formula

Locked

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

Topic

Clarifications

In reply to excel formula

Clarifications

Would this work?

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. 😉

[Author]

Replies