Combining Formulas

Shmeetbag

Board Regular
Joined
Nov 30, 2004
Messages
88
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.
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,112,814
Messages
5,542,639
Members
410,563
Latest member
csirtlab
Top