Use total minus value

The Animal

Active Member
Joined
May 26, 2011
Messages
449
Hi
I have a simple below formula that calculates the % value of a cell K270 of the cell L259 which works fime if the cell value is positive.
But if the value of the cell is negative I would like the full negative value of the cell to display rather than the % value of the negative.
For example if the value of L259 is -7529 and the % value of K270 is 75% as per below formula answer is -5647 but I want the total - value (-7529) to display but only is L259 is negative.
=L259*$K$270
Any help would be great
Thanks Stephen
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Hi,

Use an IF test:


Excel 2010
I
10
Sheet21
Cell Formulas
RangeFormula
I1=IF(L259<0,L259,L259*$K$270)
 
Upvote 0

Forum statistics

Threads
1,224,521
Messages
6,179,280
Members
452,902
Latest member
Knuddeluff

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
Back
Top