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

Very interesting problem that should be a snap to figure out!
 

Please disregard.
I got the ROUND function to work quite nicely.
Sorry to mis post.

Very interesting problem that should be a snap to figure out!
 

In B1,

=ROUND(A1/12,2)

That will make the result = 4166.67 so when it is multiplied by 12 in
C1, your result will be 50000.04.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=522815

Very interesting problem that should be a snap to figure out!
 

in B1:
=ROUND(A1/12,2)

--
Regards,
Tom Ogilvy


"KenRamoska" wrote:

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