Software

Ask something
Question Locked

excel formula

0 helpful
2 replies

by rph_herrera

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

2 replies

by thumbsup2

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. ;)

This discussion is closed to new replies.