| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
simplify equation
=IF(F5="X",+(J5),-(J5))+IF(F6="X",+(J6),-(J6))+IF(F7="X",+(J7),-(J7))+IF(F8="X",+(J8),-(J8))...
all i want is if i put an "X" in a the cell i want it to either add the number in the other cell. if i don't i want it to subtract the number in the other cell. but i don't want to have to do the busy work of typing it over and over only changing what row its in. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Equation to refer to data value(s) and not the cell?? | Excel Discussion (Misc queries) | |||
| Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
| Need Help with #N/A in equation | Excel Discussion (Misc queries) | |||
| Averaging/Rounding Equation Problem | Excel Worksheet Functions | |||
| Logarithmic Trendline Equation | Charts and Charting in Excel | |||
Threaded Mode
