Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

if statements

ResolvedVersion 2003

Anne has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course
Excel Advanced course

If Statements

a spreadsheet is automatically generated from our database the number of students that have entered for each examination.

i need to add an amount to each subject and round it up to 5.

for example:

if the entry is between 100 and 105 - this would need to be rounded up to 115.

is there an if statement i could create that would do this? bearing in mind the numbers could run between 1 and 5,000.

i would appreciate any assistance that you could give me.

thanks

anne

RE: If Statements

One solution is to use CEILING.

If A1 contained your number eg 103, then use

=CEILING(A1+10,5)

Which would give you 115 for A1 being 101 to 105

Hope that helps

Laura

Excel tip:

Quick Absolute Cell References

When entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs).

Note that the F4 key outside of editing a formula is the Repeat key to repeat a previous action.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.