Forum Discussion
Solved
Excel Formula Problem
Problem in Column I when Column D is filled with a quote number. The formula works for the first few rows but then it shows a discount when it shouldn't. See the attached worksheet example.
Why, when I drag the formula through the rows to copy it, does it not yield consistent results? Please explain.
- Try this in I5 and copy down:
=IF(($E5<=5)*($E5>0)*($D5=0),$H5*(1-$I$2),0)
