| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function problem
I have A1 and A2
subtract A2 from A1 my problem lies when those numbers fall between 12 - 12.50 I need it to still subtract them but if it falls between there, I need to additionally subtract another .50 wherever this falls, is a completely random column Is there a formula for somthing like this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
function problem
One way:
=A2-A1-(AND(A1=12,A2<=12.5)*0.5) -- Biff Microsoft Excel MVP "Scp" wrote in message ... I have A1 and A2 subtract A2 from A1 my problem lies when those numbers fall between 12 - 12.50 I need it to still subtract them but if it falls between there, I need to additionally subtract another .50 wherever this falls, is a completely random column Is there a formula for somthing like this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function Problem | Excel Worksheet Functions | |||
| MAX / MIN function problem | Excel Discussion (Misc queries) | |||
| Problem with IF function | Excel Discussion (Misc queries) | |||
| function problem | Excel Worksheet Functions | |||
| Function problem | Excel Worksheet Functions | |||
Linear Mode
