| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statement formula
Hi
Im hoping someone can assist me in creating a formula that does the following. I would like it to look at a cell, and that cell contains a number greater that 120, to return a figure of 10 for each increment of 30 over 120. For instance, if the cell contained 121 it would return '10'. If the cell contained 211 it would return '40' etc. Any ideas? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| if date statement or formula | Excel Discussion (Misc queries) | |||
| IF statement when formula result is blank | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| =IF Statement formula or conditional formatting | Excel Worksheet Functions | |||
Threaded Mode
