Rounding up and down then reducing to 2 numbers

Hi All Newbie here hopefully some one will be able to answer my question, i am creating a spreadsheet for work whereas we equate 4 figures, these figures are then rounded up or down to the nearest thousand but then reduced to 2,3 or 4 numbers depending on the 1000's 10000's or 100000's used , probably not making a lot of sense so an example is 1100+1200+15000+9000=26300 this then needs to be reduced to 26 or 27 if the equation went the other way, it would then be added to an accumulative . i have searched the web but to no avail any help would be gratefully received Adrian

1000 would =10
10000 would =100
100000 would =1000 etc

26510 would = 27
26490 would = 26 just examples

If your numbers are in a1:a4

=LEFT(SUM(A1:A4),2)+IF(MID(SUM(A1:A4),3,1)*1>=5,1,0)

take the leftmost 2 characters, then if the 3rd character is >=5 add 1 to the answer

thank you that worked perfectly is there a way for the sum to recognize whether it is able to reduce 5 numbers down to 2 6 number down to 3 and 7 numbers down to 4 all in the same equation i:e 12300=12 123000=123 and 1230000=1230 many thanks again for your help

Hi in work we have a cumulative Figure that has been going since I started work 20 years ago and is added to by either 2 numbers lets say 26 but that figure would actually be either 25910 rounded up or 26390 rounded down (these are hypothetical figures) however if the figure is greater than 5 numbers say 259100 then this would round down to 259 (3 numbers) add another figure say 2591100 then this would be rounded up or down to the nearest thousand 4 numbers, this equation=LEFT(SUM(A1:A4),2)+IF(MID(SUM(A1:A4),3,1)*1>=5,1,0) was perfect for rounding down to 2 numbers but what I require is a calculation that can recognise if its dealing with 5 numbers to reduce to 2 ,6 numbers to 3, and 7 numbers to 4 but still rounding up or down I am hoping this is possible as running 3 spreadsheets for the same calculation is not really viable Please help

my apologies for being repetitive ,yes I tried the equation in #4 many thanks it does work however it only reduces 5 numbers to the nearest 100 (3 numbers) eg 12510 becomes 125 and I require it to go to the nearest 1000 eg 13 rounding up or 12 rounding down the same with 6 numbers to the nearest 10000 and 6 numbers 100000 rounding up or down please be patient with my questions not every one was parachuted into excel

Sorry not having a lot of luck uploading the excel sheet or a pic of it

does this help as you see under the A+b+c+d box is the figure that goes through the meters this can range from 1000 to 1000000 then underneath you will see under the daily loading total it reduces to 3 numbers using the one equation I can get this down to the 2 numbers requires for figures of 10000 and above rounding off to the nearest 1000 but what I also requires for the same figure to reduce to 3 numbers for 100000 and 4 numbers for 1000000 rounding up or down to the nearest 1000 I hope this has a better understanding thank you in advance Attachment 727490

This equation got me close=LEFT(SUM(A1:A4),2)+IF(MID(SUM(A1:A4),3,1)*1>=5,1,0) this round the 5 numbers down to 2, this equation=INT(SUM(A1:A4)/100) rounded the 5 numbers to 3 so to the nearest hundred what I require is the same principle as the first equation but for the equation to realise its 5,6 or 7 numbers does that make any sense as I am finding it difficult to explain