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
|