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
|