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


---
Message posted from http://www.ExcelForum.com/

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 "
wrote in message
...
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


---
Message posted from http://www.ExcelForum.com/

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)

"Syrus the Virus " wrote in
message ...
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


---
Message posted from http://www.ExcelForum.com/

Like this????? it doesn't work

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

--
Message posted from http://www.ExcelForum.com

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)

"Syrus the Virus " wrote in
message ...
Like this????? it doesn't work

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


---
Message posted from http://www.ExcelForum.com/

One way:

=CEILING(A1,1000)

In article ,
Syrus the Virus
wrote:

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.

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!!!!!?!?!?!?!?!?!?!??!?!?!?!??!??!?!!?!?!?!? ?!?!?

--
Message posted from http://www.ExcelForum.com