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

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Watch MrExcel Video

Forum statistics

Threads
1,119,109
Messages
5,576,159
Members
412,701
Latest member
Yong girl
Top