How do I make a cell round to another cell?
One way:
A1: 0.02
B2: 0.05
C2: =ROUND(B2/$A$1,0)*$A$1
In article . com,
Aaron wrote:
Hi,
How can I make a cell with a number in it round to another cells
number.
IE Keycell is 0.02 and Answercell is 0.05 but I need it to only show
numbers in multiples of the Keycell so in this example it would round
up to 0.06?
Cheers,
Aaron.
|