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

G

Guest

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!
 
G

Guest

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

Wendy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Time Rounding in Excel 2
Force display to round down 6
Two conditions in one cell. Help needed ASAP 3
How do you round a number DOWN (for age)? 2
Rounding in Excel 2
Rounding down numbers in cell 2
How to round down to nearest 5 minutes, time calc? 6
Calculate to the third decimal and round up or down in cell 6

Top