•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Rounding my result that converts annual salary into an hourly rate by dividing by 2,080 hours
Updated Ask: Trying to get the Final annual salary to be able an even number after dividing by 52 (weeks). Ok if cents are multiple of 20 (00,.20, .40, .60, .80). Final salary cannot be greater than the Initial Salary.
Ex. 1 Initial Salary is $135,057.17
Divide by 52 = $2,597.2532...
Formula would only use $2,597.20 x 52 (round down to nearest multiple of 0.20 cents) = $135,054.40 Final Salary
Ex. 2 Initial Salary is $184,258.75
Divide by 52 = $3543.4375
Formula would only use $3543.40 x 52 (round down to nearest multiple of 0.20 cents) = $184,256.80 Final Salary
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#formula generator
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#annual salary
#Final salary
#Initial Salary
#hourly rate
#multiple of 0.20 cents
#divide by 2,080
#divide by 52
#round down
#multiple of 20
#salary adjustment
#formula
#even number
#rounding
#weeks