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, wh...
- Try this in I5 and copy down:
=IF(($E5<=5)*($E5>0)*($D5=0),$H5*(1-$I$2),0)
Try this in I5 and copy down:
=IF(($E5<=5)*($E5>0)*($D5=0),$H5*(1-$I$2),0)
=IF(($E5<=5)*($E5>0)*($D5=0),$H5*(1-$I$2),0)
- Works perfectly. Thank you!
- You're quite welcome, that's good to hear.
JMB17 How do I learn to better understand the formulas? I understand the function of the formulas provided by the community (thank you to many of you who helped) but going forward I would benefit by learning how the formulas relate to the functions I needed. What tutorials do you recommend? I do know how to create simple formulas, but nothing to the degree that you and the community offered. Do you have advice?
