Microsoft Office Forums How to change the formula

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-12-2019, 12:12 AM
LearnerExcel LearnerExcel is offline How to change the formula Windows 7 32bit How to change the formula Office 2013
Advanced Beginner
How to change the formula
 
Join Date: Nov 2016
Posts: 71
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default How to change the formula

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.
Attached Images
File Type: png To be a Blank Cell.PNG (29.0 KB, 8 views)
Reply With Quote
  #2  
Old 07-12-2019, 03:04 AM
ArviLaanemets ArviLaanemets is offline How to change the formula Windows 8 How to change the formula Office 2016
Expert
 
Join Date: May 2017
Posts: 455
ArviLaanemets will become famous soon enoughArviLaanemets will become famous soon enough
Default

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

SUM(F7) is used instead of F7 because of "-" in column F.
Reply With Quote
  #3  
Old 07-12-2019, 08:21 AM
LearnerExcel LearnerExcel is offline How to change the formula Windows 7 32bit How to change the formula Office 2013
Advanced Beginner
How to change the formula
 
Join Date: Nov 2016
Posts: 71
LearnerExcel will become famous soon enoughLearnerExcel 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
  #4  
Old 07-12-2019, 11:26 AM
LearnerExcel LearnerExcel is offline How to change the formula Windows 7 32bit How to change the formula Office 2013
Advanced Beginner
How to change the formula
 
Join Date: Nov 2016
Posts: 71
LearnerExcel will become famous soon enoughLearnerExcel 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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change the formula change formula based upon change of month invgrp2 Excel 7 05-03-2018 10:46 AM
How to change the formula 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
How to change the formula 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


All times are GMT -7. The time now is 01:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft