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
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)
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,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks