Forum Discussion
Excel Formula Adjustment
Check the Column K I've edited the formula also column I where I have replaced TEXT with Zero. Hope this work for you.
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.
Check this ,, hope will work,,, Read comments & some sample formula filled with Yellow.
Rajesh_Sinha Just one more request! See the worksheet. Can you combine the formulas (yellow and green) to create a total for EACH line?
Check M5:M11,,, if this works, the you may accept my post & Answer as well Like ☺
Rajesh_Sinha Thank you for the formula to total custom quotes, but can that command be added to the previous formula somehow. I am sorry to be such a problem. How can I get ONE formula to give me a total in Column K for each line? See my revised worksheet and comments.