Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have data in E7 and in H7. Depending on which data they want to go with I
need a formula to make a substration. If they select in L8 that they want the 50% program then in another cell I need the result of E7-M7. If they select in L8 that they want the 0% program then in another cell I need the result of H7-M7. No other options available. My attempt was the following but I got FALSE....I need the differences: =IF(L8="50%",(E8-M8),IF(L8="0%",(H8-M8),0)) Can you help??? Thanks. Carolina |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Substraction formula | Excel Worksheet Functions | |||
addition or substraction | Excel Discussion (Misc queries) | |||
variable Addition and substraction | Excel Worksheet Functions |