ExcelBanter - IFBlank Formula

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

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

- - IFBlank Formula (https://www.excelbanter.com/excel-programming/311893-ifblank-formula.html)

I'd like to run the following formula if Cells A11:A43
contain a blank. =IF(($A410)*(AND($B420)),$A41,"")

How do I go about this?

Thanks!

There is actually a ISBlank formula.

"aldricla" wrote in message
...
I'd like to run the following formula if Cells A11:A43
contain a blank. =IF(($A410)*(AND($B420)),$A41,"")

How do I go about this?

Thanks!

Thank you... How would I write the formula to populate
the cells with =IF(($A410)*(AND($B420)),$A41,"") if they
are blank using the ISBlank formula?
-----Original Message-----
There is actually a ISBlank formula.

"aldricla" wrote in
message
...
I'd like to run the following formula if Cells A11:A43
contain a blank. =IF(($A410)*(AND($B420)),$A41,"")

How do I go about this?

Thanks!

.

Here is a formula that I use to do a calculation if the user enter something
into cell A5

=IF(NOT(ISBLANK(A5)),(E4)+(C5)-(D5),"")

You would want something like this:

=IF(NOT(ISBLANK(SomeCell)),(=IF(($A410)*(AND($B42 0)),$A41,"")),"")

There might be a problem with the parentheses in the above, I didn't try it.

"aldricla" wrote in message
...
Thank you... How would I write the formula to populate
the cells with =IF(($A410)*(AND($B420)),$A41,"") if they
are blank using the ISBlank formula?
-----Original Message-----
There is actually a ISBlank formula.

"aldricla" wrote in
message
...
I'd like to run the following formula if Cells A11:A43
contain a blank. =IF(($A410)*(AND($B420)),$A41,"")

How do I go about this?

Thanks!

.