Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is there such a function?
Hi, I am looking for a formula that will round any amount over a multiple of
$100 to the next $100. So, for example, Input -- Output $0 -- $0 $1 -- $100 $50 -- $100 $100 -- $100 $169 -- $200 $200 -- $200 $201 -- $300 etc. Is there such a formula, and would it involve ROUND, since this is not really rounding? Also, can anyone tell me what the syntax of the ROUND formula is? =ROUND(?,?) I want to know so I will be able to compute this for myself in the future. And is there a list of all known Excel formulae? Thanks! Julie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions |