codedreamer
New Member
I have several conditionals in a cell is something like this: =IF(AND(A1<2,B2>4),"1")
How do I get the result to be an empty cell if either A1 or A2 are blank(no data in them)?
I tried isblank, but did not worked for me, I also tried saying A1="", but it did not work either, neither <> worked. Any help is appreciated.
Thanks.
How do I get the result to be an empty cell if either A1 or A2 are blank(no data in them)?
I tried isblank, but did not worked for me, I also tried saying A1="", but it did not work either, neither <> worked. Any help is appreciated.
Thanks.