View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EBronco67
 
Posts: n/a
Default 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.