| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates in fomula showing as whole number | New Users to Excel | |||
| How do I round a number to the nearest .49 in a cell that has a fo | Excel Worksheet Functions | |||
| Fomula for number of days on each month from a date range | Excel Discussion (Misc queries) | |||
| Can I format a cell to round a number by 50 basis points (0.5)? | Excel Worksheet Functions | |||
| include maximum number in fomula | Excel Worksheet Functions | |||
Linear Mode
