| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Very interesting problem that should be a snap to figure out!
Hi,
I have 3 cells A1 has $50,000 B1 has the formula =A1/12 C1 has the formula =B1*12 B1 comes up as 4166.67 its really .6666667 to infinity...you get the idea So when I redo it I really want the answer in C1 to be 50000.04 which truly is 4166.67 * 12 How do I get Excel to not see the infinite decimal and truly stop at 2 decimals I need to start at 50,000 but end at 50000.04 after the 2 formulas are done. Thanks in advance for any advice |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF problem using Solver | Excel Worksheet Functions | |||
| Interesting TIF file problem | Excel Discussion (Misc queries) | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
| problem office assistant | Excel Discussion (Misc queries) | |||
| Paper Tray selection Problem, | Excel Discussion (Misc queries) | |||
Threaded Mode
