How to change the formula

LearnerExcel · #1 07-12-2019, 12:12 AM

Hi,

Need to change the formula to keep Cell G7 Blank if both Cells D7 & F7 are Blank Cells. How can I do that? Please do help.

ArviLaanemets · #2 07-12-2019, 03:04 AM

Code:

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

SUM(F7) is used instead of F7 because of "-" in column F.

LearnerExcel · #3 07-12-2019, 08:21 AM

[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? ".

LearnerExcel · #4 07-12-2019, 11:26 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
change formula based upon change of month	invgrp2	Excel	7	05-03-2018 10:46 AM
How to change the formula to get this result ....	LearnerExcel	Excel Programming	2	02-11-2018 08:26 PM
I need to change a formular to overide formula	shanni11	Excel	1	09-10-2016 12:09 AM
Bulk formula change	dlearyfun	Excel	1	10-26-2014 09:44 AM
xl table formula change on add row	mikec	Excel Programming	6	11-10-2013 04:54 PM