Combining Formulas

[Shmeetbag]

I am having trouble combining some formulas. In one formula I am trying to increase 1125 by 6% (1192.5) and return a number rounded to the nearest 5 (1195). Here is the scenario.

Input Cells:
A1 = 6%
B1= 1125

Here are the two formulas that will bring out the correct solution, but I am unable to combine.

=SUM(B1*$A$1)+B1
=ROUND(C1/5,0)*5

Thanks for any input.

 

[onlyadrafter]

Hello

=ROUND(SUM((B1*$A$1)+B1)/5,0)*5

 

[Andrew Poulsom]

I don't know why you are using SUM there. How about?

=ROUND(B1*(1+A1)/5,0)*5

 

[Shmeetbag]

Thanks, the formulas work great.