Excel Formula Help

[sfpcservice]

I'm trying to build a formula that will multiply a cell by 1.5 if the cell is a negative value and by 0.5 if the cell is positive. This is what I have:
=if(OR(A41<0,A41>0),A41*0.5,A41*1.5)

The results I get are only multiplied by the 0.5 though, it's like it never goes over to the 1.5 side no matter what the value is.

What am I doing wrong?

[jimmykan]

Just use nested IFs.

=IF(A41<0,A41*1.5,IF(A41>0,A41*0.5,A41))

The "0" case will take care of itself.

[sfpcservice]

Just use nested IFs.

Can you help me? I thought that's what I did...

[9Cal_OC]

Just use nested IFs.

=IF(A41<0,A41*1.5,IF(A41>0,A41*0.5,A41))

The "0" case will take care of itself.

This. The OR statement you have will always be true, hence only computing the true statement, and never the false.

[sfpcservice]

Just use nested IFs.

=IF(A41<0,A41*1.5,IF(A41>0,A41*0.5,A41))

The "0" case will take care of itself.

Thanks I didn't see your formula on my 1st response. Whats the purpose of the large a41 in the formula?

[9Cal_OC]

Thanks I didn't see your formula on my 1st response. Whats the purpose of the large a41 in the formula?

In case the input is a zero, it outputs zero.