How to change the formula

		Microsoft Office Forums > Microsoft Excel > Excel
How to change the formula

07-12-2019, 08:21 AM

LearnerExcel LearnerExcel is offline

Windows 7 32bit How to change the formula

Office 2013

Advanced Beginner

Join Date: Nov 2016

Posts: 82

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

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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:46 AM.