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...
Awolbert
Feb 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_Sinha
Feb 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.
- Rajesh_SinhaFeb 27, 2021Iron Contributor
Check this ,, hope will work,,, Read comments & some sample formula filled with Yellow.
- AwolbertMar 01, 2021Brass Contributor
Rajesh_Sinha Just one more request! See the worksheet. Can you combine the formulas (yellow and green) to create a total for EACH line?