Sorry! it is 100% not 127%.

Please try again.



"Danny Lewis" wrote:

You sit on Excel for hours, days on end, working, and every now and again you
do the SIMPLEST thing and it's not working.

It's a wonder my monitor is still in the building and not out the window...

I will simplify my problem for ease of reading

In column A are the letters A-Z from A3:A28
In column B are random numbers from B3:B28
In B30 is the total of those random numbers.

In C3:C28 is the numbers in B3:B28 expressed as a percentage of the total
(B30)

ie say B12 is 20, and the total is 100, C12 would read 20%.

The formula in each of the cells in column C is
=IF(ISERROR($B3/$B$30),"",$B3/$B$30) and so on, this is run from row 3 to 28.

Here's the funny bit: the numbers in column C add up to 127%.

Any clues? lol