Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Sirs,
I can format a calculated cell value to display as the nearest whole number. But is it possible to have that rounded whole number value (not the cell's calculated fractional value) become the value recognized and used when it is a term in follow-on fomulas? For example; if cell A5 represents the number of bolts needed to attach a frame and the next calculation uses A5 as a multiplier with A6, which is the unit price-per screw and the you want the total cost to automate as the answer in cell A7, then cell A5 needs to be a whole number. Is this possible? If so, what do I need to do. I appreciate your help! -- A. Stretcher |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
functioning of formulas | Excel Worksheet Functions | |||
conditional formating not functioning in cell with formula? | Excel Discussion (Misc queries) | |||
Why do my formulas quit functioning in Excel 2007? | Excel Worksheet Functions | |||
protected excel2003 document. Name Cell not functioning. | Excel Worksheet Functions | |||
use the number in one cell for different formulas | Excel Worksheet Functions |