IFBlank Formula

[aldricla]

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

How do I go about this?

Thanks!

 

[Township of East Hanover]

There is actually a ISBlank formula.

 

[aldricla]

Thank you... How would I write the formula to populate
the cells with =IF(($A41>0)*(AND($B42>0)),$A41,"") if they
are blank using the ISBlank formula?

 

[Township of East Hanover]

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(($A41>0)*(AND($B42>0)),$A41,"")),"")

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