Re: Sum + Round Up

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Canon wrote:
Excel 2007
Using the following formula, =sum(A4*$B$3), I would like the amount to always round up to the next 5
ie: if the true answer is $45.12, I would like the cell to show $45.15

Try this:
=CEILING(100*(A4*$B$3),5)/100

Or maybe this if you intend to sum a range:
=CEILING(100*SUM(A4:A6)*$B$3,5)/100

.

Relevant Pages

  • Re: A Mortar as a Flack Canon
    ... A singel cartoon like canon ball filled with explosives can do ... should destroy ALL aircraft within 100 yards. ... the huge round. ... I agree that the slower motar round would be harder to radar target. ...
    (sci.military.naval)
  • Re: The Ultimate - A No-Numbers Dsplacement Cipher -Adacrypt.
    ... If the biological easters can amount ... the organic solicitor may round more treasurys. ...
    (sci.crypt)
  • Re: Deal or no deal
    ... Only right at the end do they offer you an amount that's either ... In round 1, with 20 cases remaining, the offer is around 11% of the ... When it gets down to 5 suitcases, you have to take a look at the board ... the bank- so the offers could be related to expectation (and probably ...
    (rec.puzzles)
  • Re: Export Table Data To Formatted Text File
    ... LOL. ... Coming back refreshed and with an open mind often times provides solutions....I was too buried in the trees to see the forest. ... One of the fields I have to export to this text file is a number field formatted as a double that represents a dollar amount. ... You really would want to round a double...who knows what the real value of the number is. ...
    (comp.databases.ms-access)
  • Re: Finding an Unknown Equation
    ... does the banker know the amount in the selected case. ... First round drops 6 cases so you go down to 19 cases left. ... and I do have some stats background but has been about 1-2 ...
    (comp.soft-sys.matlab)