| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statement query
Hi
Im hoping someone can assist me in creating a formula that does the following. I would like to look at cell A1 and if that cell contains a number greater than 120, to return a figure of 10 for each increment of 30 over 120 but if A1 contains a figure less than 120 it should return a figure of minus 10 for each increment of 30 under 120. If the cell A1 is 0 then it should return a 0. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems importing from an Access query | Excel Discussion (Misc queries) | |||
| changing query source | Excel Worksheet Functions | |||
| AHHH! Again | Excel Discussion (Misc queries) | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
| "Query cannot be edited by the Query Wizard" | Excel Discussion (Misc queries) | |||
Threaded Mode
