| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF statements
I wish to create a cell that gives a rounded up/rounded down figure i.e.
Assume figure of 20.38 The number before the decimal point will be variable. The number after the decimal point will be subject to the following conditions:- If < .124 then round down to next whole 0.5 (if 20.38 then figure to be 20.0) If .124 then round up to next whole 0.5 (if 20.38 then figure to be 20.5) If < .624 then round down to next whole 0.5 (if 20.45 then figure to be 20.5) If .624 then round up to next whole 0.5 (if 20.72 then figure to be 21.0) How do I write the formula please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If And statements -- HELP! | Excel Worksheet Functions | |||
| If then statements | Excel Discussion (Misc queries) | |||
| how to do if and or else statements | Excel Worksheet Functions | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
| if statements | Excel Worksheet Functions | |||
Threaded Mode
