use one instead 2 formulas?

[saso_MK]

I need a little help with my formulas.
I would like to make more complex formula and avoid using 2 columns with formulas, when decreasing values with percentage.

I would like to avoid column C, and have result complete in column D with one formula.

Is this possible?

Can anybody help? ...thanks in advance.


The sample file is attached

[Domenic]

Try...

C2, copied down:

=A2-(A2*IF(B2="1",5,IF(B2="2",2))/100)

I'm not sure why you've formatted the numbers returned by the formula in Column B as text. It could pose a potential problem in some mathematical calculations. You may want to consider the following instead...

B2, copied down:

=IF(A2>119,1,IF(A2>89,2,))

C2, copied down:

=A2-(A2*IF(B2=1,5,IF(B2=2,2))/100)

[saso_MK]

Thank you Domenic.
Nice point and problem solved.
I used text as return as I am newbee... in this, but your suggestion is right.

Regards,