Mar 08 2021 04:01 PM
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.
Mar 08 2021 10:25 PM
SolutionMar 10 2021 12:52 PM
@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?
Mar 10 2021 09:24 PM
Mar 08 2021 10:25 PM
Solution