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.
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.