| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Round off to 100 numbers?
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Rounding numbers up or down | Excel Discussion (Misc queries) | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
| Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
| finding common numbers in large lists | Excel Worksheet Functions | |||
Threaded Mode
