98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » If Statements
If Statements
Resolved · 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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Closing Multiple Open Worksheets At OnceWhen 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. |