IF positive/If negative????

[CadensDad]

I have a column set up where I will be entering numbers. My problem is
that if the number is entered as a negative number I want the cell to
the right of it to do a certain calculation. However if the number I
enter is a positive number I would like a different calculation to be
done in that cell to the right. I hope I am not too confusing on this.


Basically when all is said and done I would like Ex.

A1 has -130 entered in it then A2 has the result of 1.77 (rounded to 2
dec. points)
or
A1 has 120 entered in it then A2 would have the result of 2.2

here is how I get to those numbers
my calculation for the cells are for A1 is 1+(100/130) giving a 1.77. I
would like the negative number entered actually changed to a positive
for this calculation.

for there is a positive number entered I would like this calculation.

1+(120*.01) giving a 2.2

 

[Richard Buttrey]

=IF(A1<0,1+ABS(100/A1),1+(A1*0.01))

Rgds

I have a column set up where I will be entering numbers. My problem is
that if the number is entered as a negative number I want the cell to
the right of it to do a certain calculation. However if the number I
enter is a positive number I would like a different calculation to be
done in that cell to the right. I hope I am not too confusing on this.


Basically when all is said and done I would like Ex.

A1 has -130 entered in it then A2 has the result of 1.77 (rounded to 2
dec. points)
or
A1 has 120 entered in it then A2 would have the result of 2.2

here is how I get to those numbers
my calculation for the cells are for A1 is 1+(100/130) giving a 1.77. I
would like the negative number entered actually changed to a positive
for this calculation.

for there is a positive number entered I would like this calculation.

1+(120*.01) giving a 2.2

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________