ExcelBanter - Please ammend Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Please ammend Formula (https://www.excelbanter.com/excel-programming/390209-please-ammend-formula.html)

Burhan Uddin[_2_]

Please ammend Formula

Can anyone please amend this formula for me.

=IF(SUM(NOW()-E:E)2,"YES","")

I want the above formula to be functional only if G:G has null value in it.
Please somebody guide me with this.

Thank You.

Sebation.G[_2_]

Please ammend Formula

try:
=IF(ISBLANK(G:G),your fomula," ")

HTH

--
Regards,

Sebation.G

"Burhan Uddin" <Burhan ...
Can anyone please amend this formula for me.

=IF(SUM(NOW()-E:E)2,"YES","")

I want the above formula to be functional only if G:G has null value in
it.
Please somebody guide me with this.

Thank You.

Burhan Uddin

Please ammend Formula

Thanks dear.

"Sebation.G" wrote:

try:
=IF(ISBLANK(G:G),your fomula," ")

HTH

--
Regards,

Sebation.G

"Burhan Uddin" <Burhan ...
Can anyone please amend this formula for me.

=IF(SUM(NOW()-E:E)2,"YES","")

I want the above formula to be functional only if G:G has null value in
it.
Please somebody guide me with this.

Thank You.

All times are GMT +1. The time now is 07:38 PM.