Link to home
Start Free TrialLog in
Avatar of Frank .S
Frank .SFlag for Australia

asked on

excel 2016 - round down in increments

hi experts, can you help with the following formula
- 1st issue is dividing by 1million because all referenced qtys are in mm, is there another solution?
- 2nd issue is the actual formula is producing an error (nothing to do with the divide by 1million)
- i just want the formula to round down to nearest 0.1 increment
=IF(G19="","",FLOOR(G19*H19*I19)/1000000,.01)


ASKER CERTIFIED SOLUTION
Avatar of Bembi
Bembi
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
And your first question...yes this is the way...
To reduce number of characters and/or keystrokes when entering the formula, you can also use 10^6 rather than 1000000
Avatar of Frank .S

ASKER

thanks Rob! yes this is VERY helpful!