Frank .S
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)
- 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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
ASKER
thanks Rob! yes this is VERY helpful!