The cell "H2" has a number, like 556$, and some times like 64$ etc.

In another cell "A1" I want 20 % of that value, and I have the formel
"=H2*0,2"

And I wan't the cell to round off to "100" number. How can I do that?

Like 64$, says 100$ in A1.
Like 556$, says 600$ in A1.

You get it! Please help me.

Foppa wrote:
The cell "H2" has a number, like 556$, and some times like 64$ etc.

In another cell "A1" I want 20 % of that value, and I have the formel
"=H2*0,2"

And I wan't the cell to round off to "100" number. How can I do that?

Like 64$, says 100$ in A1.
Like 556$, says 600$ in A1.

You get it! Please help me.

======================

One approach would be [ ]=100*Round(A1/100,0)

Bill

=ROUND(A1,-2)

If you perchance want to round-up (46-100) then

=CEILING(A1,100)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Foppa" wrote in message
...
The cell "H2" has a number, like 556$, and some times like 64$ etc.

In another cell "A1" I want 20 % of that value, and I have the formel
"=H2*0,2"

And I wan't the cell to round off to "100" number. How can I do that?

Like 64$, says 100$ in A1.
Like 556$, says 600$ in A1.

You get it! Please help me.

Maybe put one of these in A1..........
=ROUND((H2*0.2),-2)
or
=CEILING((H2*0.2),100)

Vaya con Dios,
Chuck, CABGx3


"Foppa" wrote in message
...
The cell "H2" has a number, like 556$, and some times like 64$ etc.

In another cell "A1" I want 20 % of that value, and I have the formel
"=H2*0,2"

And I wan't the cell to round off to "100" number. How can I do that?

Like 64$, says 100$ in A1.
Like 556$, says 600$ in A1.

You get it! Please help me.