Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've got a lot of data that I'm trying to enter into an excel spreadsheet.

All the data in columns after the first are of the form:

Previous column data * 1.3 {rounded up to the nearest multiple of 5}

The Previous Column data * 1.3 is easy enough to set up, but I am looking for a way to handle the part of the equation in { } brackets.

Any suggestions?

share|improve this question
up vote 2 down vote accepted

Excel has a built-in ceiling function: =CEILING(CELL, SIGNIFICANCE) where CELL is your data (say A1) and SIGNIFICANCE is your rounding value - 5 in your case.

So if you have the original data in cell A1 - the complete formula to do what you're asking is:

=CEILING(A1*1.3,5)
share|improve this answer
    
Worked like a charm. – Raven Dreamer Oct 12 '10 at 19:53

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .