# Combining Formulas

#### Shmeetbag

##### Board Regular
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.

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

#### onlyadrafter

##### Well-known Member
Hello

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

#### Andrew Poulsom

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

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

#### Shmeetbag

##### Board Regular
Thanks, the formulas work great.

Replies
1
Views
85
Replies
2
Views
37
Replies
2
Views
49
Replies
5
Views
70
Replies
10
Views
172

Threads
1,108,924
Messages
5,525,656
Members
409,658
Latest member
Yardcell