Use total minus value

[The Animal]

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

 

[jtakw]

Hi,

Use an IF test:

Excel 2010
	I
1	0
Sheet21

Cell Formulas
Range	Formula
I1	=IF(L259<0,L259,L259*$K$270)

 

[The Animal]

Brilliant Thanks

 

[jtakw]

You're welcome.