Basically I want to be able to input the pay rate (ex: enter "14" to symbolize 14 dollars per hour) into the cell that already has a formula to get a result (In the same cell.).
If I input 14 in D20 I'll get 2426.67 as the result.
The formula is (((inputed value) * (40) * (52)) / (12))
- 40 weekly hours
- 52 is weeks in a year
- 12 is monthly
Is it possible?
No comments:
Post a Comment