Combine Round with IF statement

[gambils]

I have an if statement that is giving me a value, let's say 29, but I wanted it rounded to the nearest 5 - in this case, 30. How would I combine the round function with my if statement to give me that result?

 

[Scott Huish]

Replace the A1 with your IF statement minus the = in your formula.

=ROUND(A1/5,0)*5

 

[njimack]

=CEILING(A1,5) will round the value in A1 up the nearest 5.

 

[Misca]

I have no idea of your IF-statement but try something like:

Excel Workbook
	A	B
1	29	30
Sheet

 

[gambils]

I have initially used Hot Pepper's formula as it made a little more sense to me and it works! But I will try the others also- thanks to all!

 

[Abhisk007]

I have this formula to make ESI whose salary over 21000 they will be out of ESI and those who are below 21000 their ESI will be 1.75% of gross. Now i Need how i add roundup with this formula so that i can get amount like this 12000.00 not like this 12000.25

Please help me.

=IF(Q8>21000,Q8*0%,IF(Q8<=21000,Q8*1.75%,0))

 

[Scott Huish]

Q8 * 0% is 0, so this check isn't necessary. The only time you are doing any multiplication is if Q8<=21000.
So:

=ROUNDUP(IF(Q8<=21000,Q8*1.75%,0),0)

or without the IF:
=ROUNDUP(Q8*(Q8<=21000)*1.75%,0)