Microsoft Office Forums - View Single Post - [Solved] How to change the formula

Thread: [Solved] How to change the formula

View Single Post

Old

07-12-2019, 11:26 AM

LearnerExcel LearnerExcel is offline

LearnerExcel is offline

LearnerExcel uses Windows 7 32bit

Windows 7 32bit LearnerExcel uses Office 2013

LearnerExcel uses Office 2013

Office 2013

Advanced Beginner

The original poster

Join Date: Nov 2016

Posts: 82

LearnerExcel will become famous soon enough

LearnerExcel will become famous soon enough

Default

The problem is resolved. Just removed one "I" from the "IIF" in the below formula and now it is working fine.
If(AND(D7 = "", F7=""), "", G6+D7-SUM(F7))

Thanks for the support.

Reply With Quote