negative number division

tmm40

New Member
Joined
Sep 8, 2002
Messages
5
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

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
welcome to the board!

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

Paddy
 

tmm40

New Member
Joined
Sep 8, 2002
Messages
5
Thanks for your response Paddy!!
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!!
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
what if they're one of each? does it matter if the negative is the denominator or numerator?
 

tmm40

New Member
Joined
Sep 8, 2002
Messages
5

ADVERTISEMENT

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!
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
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))

Paddy
 

tmm40

New Member
Joined
Sep 8, 2002
Messages
5

ADVERTISEMENT

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!!
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
sorry, my error with the brackets:

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

tmm40

New Member
Joined
Sep 8, 2002
Messages
5
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!!
 

Forum statistics

Threads
1,144,217
Messages
5,723,063
Members
422,477
Latest member
pete101

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top