Forum Discussion
Excel Formula IF(AND(A1=0,B1=0),0,0),IF(A1>B1,1,0) ends with #value error.
Hi, I am using Excel 365. Using plain single sheet and cells A1 and B1. The formula is in C4 where I want the answer, Formula is IF(AND(A1=0,B1=0),0,0),IF(A1>B1,1,0). Always comes up with #VALUE err...
Your formula is =IF();IF(). That is not a valid formula.
It should be:
=IF(AND(A1=0,B1=0),0,IF(A1>B1,1,0))
A shorter way to achieve the same:
=(A1>B1)*1