View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Skip[_2_] Skip[_2_] is offline
external usenet poster
 
Posts: 29
Default I have a column of numbers, some negative, some positive

I have some calulations in my worksheet. They are done twice, if my
number is positive or negative.
I need to fill the cell next to my number with the calulation that
correspondes with the + or - of my number.


if A1 + if A1 -
A1 B1 C1 D1
-10 7 12

A2 B2 C2 D2
14 4 6
I need the 12 to appear in B1.

and the 4 to appear in B2.
Thanks