if statements

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » If Statements

If Statements

resolvedResolved · High Priority · Version 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

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Closing Multiple Open Worksheets At Once

When multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option.

Close All menu option is only displayed when Shift key is down

View all Excel hints and tips


Server loaded in 0.09 secs.