Blackie50
10-08-2010, 03:08 AM
Hi
Have the following code that splits a number up but its sometomes out because of the roundings e.g. £6200.02 splits to £6200.03.
Range("d18,k18").Value = Range("n7").Value * 10 / 100
Range("d19,k19").Value = Range("n7").Value * 28 / 100
Range("d20,k20").Value = Range("n7").Value * 5 / 100
Range("d21,k21").Value = Range("n7").Value * 5 / 100
Range("d22,k22").Value = Range("n7").Value * 26 / 100
Range("d23,k23").Value = Range("n7").Value * 26 / 100
How do I get the round function in there?
thanks
Jon
Have the following code that splits a number up but its sometomes out because of the roundings e.g. £6200.02 splits to £6200.03.
Range("d18,k18").Value = Range("n7").Value * 10 / 100
Range("d19,k19").Value = Range("n7").Value * 28 / 100
Range("d20,k20").Value = Range("n7").Value * 5 / 100
Range("d21,k21").Value = Range("n7").Value * 5 / 100
Range("d22,k22").Value = Range("n7").Value * 26 / 100
Range("d23,k23").Value = Range("n7").Value * 26 / 100
How do I get the round function in there?
thanks
Jon