#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Code:
IIf(AND(D7 = "", F7=""), "", G6+D7-SUM(F7)) SUM(F7) is used instead of F7 because of "-" in column F. |
#3
|
|||
|
|||
[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? ". |
#4
|
|||
|
|||
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 |