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, 08:21 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

[QUOTE=ArviLaanemets;143199]

Code:

 IIf(AND(D7 = "", F7=""), "", G6+D7-SUM(F7))

Thanks for your kind reply. But I am getting this error in Cell G7 " #NAME? ".

Reply With Quote