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

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.

Watch MrExcel Video

Forum statistics

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

This Week's Hot Topics

Top