| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula for a pension
"barbarat" wrote:
Hello again...yes, I think I understand it. Great. The INT is for rounding, right? Well, for truncating. It will match $1 to $1 through $1.99. If you want to round (match $2 to $1.50 through $2.49), change INT(...) to ROUND(...,0). If you want to match $2 to $1.01 through $2 -- i.e, to any dollar or part thereof -- use ROUNDUP(...,0) or CEILING(...,1). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide formula | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
Threaded Mode
