| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula referring to a decimal portion of another cell
What formula would I use for the following:
B3 contains the following formula: =(A2-e4)/18 I wish B3 to be to be displayed as a whole number rounded down. If the actual value of B3 is, for example, 7.6, I would like another cell to reflect .6 x 18, rounded up |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excel formula referring to a decimal portion of another cell
=INT((A2-E4)/18)
=MOD((A2-E4)/18,1) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "teenerx5" wrote in message ... What formula would I use for the following: B3 contains the following formula: =(A2-e4)/18 I wish B3 to be to be displayed as a whole number rounded down. If the actual value of B3 is, for example, 7.6, I would like another cell to reflect .6 x 18, rounded up |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A formula for moving a portion of a cell??? | Excel Discussion (Misc queries) | |||
| Formula referring to a different sheet | Excel Discussion (Misc queries) | |||
| formula works when referring to one cell but not to another | New Users to Excel | |||
| how do i operate on the decimal portion of a number | New Users to Excel | |||
| how do i extend the series of a portion of a formula? | Excel Worksheet Functions | |||
Linear Mode
