How do I round down a number in a cell w/ a fomula in it?
 

I am trying to calculate income. The cell already contains the following
formual =C6*D6 and is set to two decimal places. I need to make sure it's
rounding down as well but can't get the rounddown formula to reference the
cell it is in. (i.e. the total income is in cell F6 but I can't use
=rounddown(f6,2) in F6 as well as =C6*D6.

Help!! All those rounded up pennies start adding up!

How do I round down a number in a cell w/ a fomula in it?
 

Wendy,
in F6 put =Rounddown(c6*d6,2)

"Wendy Kay" wrote:

I am trying to calculate income. The cell already contains the following
formual =C6*D6 and is set to two decimal places. I need to make sure it's
rounding down as well but can't get the rounddown formula to reference the
cell it is in. (i.e. the total income is in cell F6 but I can't use
=rounddown(f6,2) in F6 as well as =C6*D6.

Help!! All those rounded up pennies start adding up!

How do I round down a number in a cell w/ a fomula in it?
 

You are the bomb!! I was having an "Office Space" moment and you fixed it.
Thanks much and Happy Holidays!!

Wendy

"Toppers" wrote:

Wendy,
in F6 put =Rounddown(c6*d6,2)

"Wendy Kay" wrote:

I am trying to calculate income. The cell already contains the following
formual =C6*D6 and is set to two decimal places. I need to make sure it's
rounding down as well but can't get the rounddown formula to reference the
cell it is in. (i.e. the total income is in cell F6 but I can't use
=rounddown(f6,2) in F6 as well as =C6*D6.

Help!! All those rounded up pennies start adding up!