use one instead 2 formulas?

saso_MK · #1 07-02-2009, 08:59 PM

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 · #2 07-02-2009, 09:11 PM

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 · #3 07-02-2009, 09:38 PM

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,

Welcome to the Excel Forum

Forum Statistics