can anyone help me round down to the nearest 10,000
So, if it's 84,000, it'll round to 80,000
If It's 86,000, it'll round to 80,000
I found this online, but it doesn't work properly past 100,000..it just rounds down to the nearest 100,000 when it gets past 100,000...
The formula of round currently rounds up if the decimal value is 0.5 and above and rounds down if the decimal value is below 0.5.
Is there a way to change this? I want a round up if the decimal value is 0.8 and above and round down if the decimal value is 0.7 and below.
If value is 2.7...
Assume Product is Part A and Qty is 4 for the following fields. What is the formula I need to enter to return the correct price for the given quantity?
(I expect the formula to output 25.87)
Field values are as follows:
A1:Product B1:Price C1:Qty Start D1: Qty End
A2:PartA B2:10.35 C2:50 D2:500...