# negative number division

#### tmm40

##### New Member
I am dividing two negative numbers from seperate columns,(that come from other sets of formulas in other columns). I would like the result to display as a negative number instead of the current positive result. Any suggestions?

By the way, I have just found this site and I am amazed at the knowledge here!!!

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
welcome to the board!

simple (but hopefully not facile) solution - multiply the result by -1 ?

The problem is that some of the columns are also positive, and when they are I would like them displayed as positive. I am not that good at excel, but is there a way I can put an argument that if the columns being divided are negative, then the result is displayed as negative? And if positive the result is displayed as positive?
Hope I am being clear enough! And thanks again for your help!!

what if they're one of each? does it matter if the negative is the denominator or numerator?

The numbers will always be both negative or both positive, as these numbers come from other formulas. It just would make it much easier in this case to have the result show negative or positive the same as the numerator/denominator.

Thanks again!

If both numbers are always either +ve or -ve, you only ever need to check one of them.

something like:

=if((a1<0,(a1/b1)*-1,(a1/b1))

Hmmmmm, it made all the sense in the world to me, but excel differs with both of us!!
Here is a copy and paste of the exact cells-

=if((k3<0,(k3/j3)*-1,(k3/j3))

But excel says there is something wrong.
I'll have to look at it tomorrow and see what I am doing wrong. Thanks for your help!!
What a great place you have here!!

sorry, my error with the brackets:

=if(k3<0,(k3/j3)*-1,k3/j3)

I tried that and excel came back with this suggestion-

=IF(K3<0,(K3/J3)*-1,(K3/J3))

and it worked!!!!!!!

Thank you so much Paddy!!! I will be back again I am sure!!!
Have a great night!!

Replies
4
Views
309
Replies
3
Views
170
Replies
16
Views
1K
Replies
1
Views
281
Replies
3
Views
475

1,217,329
Messages
6,135,923
Members
449,973
Latest member
jarzack

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back