vijay.vizzu
Member
Dear All
I came up with strange question that how to round up 9 digits ? The question may be strange. Lets elaborate more.. In a cell A1, if the cell value is between the 1-9 then it should round up by 9 digits otherwise it should round down. For example
281 should be displayed as 290
9 should be displayed as 10
8 should be displayed as 10
249 should be displayed as 250
I hope you all understand the question, awaiting your reply
I came up with strange question that how to round up 9 digits ? The question may be strange. Lets elaborate more.. In a cell A1, if the cell value is between the 1-9 then it should round up by 9 digits otherwise it should round down. For example
281 should be displayed as 290
9 should be displayed as 10
8 should be displayed as 10
249 should be displayed as 250
I hope you all understand the question, awaiting your reply
