Forum Discussion
Awolbert
Feb 25, 2021Brass Contributor
Excel Formula Adjustment
I need help with an "IF" formula. I received tips from this community to create formulas in the attached spreadsheet but I need one more contingency formula. I am offering quantity discounts in two t...
Rajesh_Sinha
Feb 25, 2021Iron Contributor
Awolbert ,,
Check the attached WB and find the modified formula in Column I and J,, read the comment also.
- AwolbertFeb 25, 2021Brass Contributor
Rajesh_Sinha Nevermind! I think I got it from a previous reply. Thank you so much. How do I change the text in columns I and J? I would like it to be blank. Dollar sign format.
- Rajesh_SinhaFeb 26, 2021Iron Contributor
Check the Column K I've edited the formula also column I where I have replaced TEXT with Zero. Hope this work for you.
- AwolbertFeb 26, 2021Brass Contributor
Rajesh_Sinha I need an IF, THEN formula for Column K when Column D is filled. Please see the attached page. And thank you so much for your quick responses. You are helping me immensely.
- AwolbertFeb 25, 2021Brass Contributor
Rajesh_Sinha What about the extension column K? See attached WB green highlights. Can you adjust the sum in column K to capture H, I, J multiplied by E?