Rounding

  • Thread starter Thread starter Syrus the Virus
  • Start date Start date
S

Syrus the Virus

Hey Guys and Galls,

Problem: I have got number from 1 to 99999999. I want Every result to
be check and when the number is between 1 to 999 it needs to be rounded
to 1000, 1001 to 1999 needs to become 2000 etc.

Sollution: I don't havre any that's why I asked.

Tnxs in advance
 
You can use a formula like

=ROUNDUP(A1,-3)

where A1 is the value to be rounded.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Syrus the Virus >"
 
Use this formula and copy down

=ROUNDUP(A1,-3)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Like this????? it doesn't work

Sheets("Materialview").Cells(L, k) = "RoundUp(A1, -3)
 
No, like this

Sheets("Materialview").Cells(L, k) =
WorksheetFunction.RoundUp(Range("A1"), -3)


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
For some of you it ain't easy to see................................
If I knew how to work excel like you do awnsers like =CEILING(A1,1000
and functions that don't work would be clear t
me.............................................................

My situation:

A variable cell need to be rounded
A cell with the Row L and Column k from sheet MaterialView
It already contains the data put in variable E this data needs t
rounded and be put away in cell Row L + 1 and Column k + 1

Now does anyone can help me with an awnser for stupi
people!!!!!?!?!?!?!?!?!?!??!?!?!?!??!??!?!!?!?!?!??!?!?
 
Back
Top