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