How do I write this in a formula
If Cell E33 is equal or greater than 0 and if A33 is blank then leave active cell Z33 empty.
but
If Cell E33 is not equal to but greater than 0 and if A33 is not blank then return E33's value to Z33
I might be way off. Thanks
If Cell E33 is equal or greater than 0 and if A33 is blank then leave active cell Z33 empty.
but
If Cell E33 is not equal to but greater than 0 and if A33 is not blank then return E33's value to Z33
Excel Formula:
=IF(and(E33>=0,A33="","")
=IF(and(E33>0,A33<>"",E33,"")
I might be way off. Thanks