IF positive/If negative????
 

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


--
CadensDad
------------------------------------------------------------------------
CadensDad's Profile: http://www.excelforum.com/member.php...o&userid=17469
View this thread: http://www.excelforum.com/showthread...hreadid=476222

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

Rgds

On Fri, 14 Oct 2005 07:45:09 -0500, CadensDad
wrote:


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
__________________________