How to change the formula

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

FAQ

Thread Tools

Display Modes

07-12-2019, 11:26 AM

LearnerExcel LearnerExcel is offline

Windows 7 32bit How to change the formula

Office 2013

Advanced Beginner

Join Date: Nov 2016

Posts: 82

LearnerExcel will become famous soon enough

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.

« Previous Thread | Next Thread »

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 12:38 AM.