# Software

## Question

Locked

### excel formula

By ·
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 +

Collapse -

### Would this work?

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

## Related Discussions

• 1

#### Blackboard Collaborate

helloRepublic ·

• 2

coryjames ·

• 0

Jon ·

• 3