Home

Excel Formula IF(AND(A1=0,B1=0),0,0),IF(A1>B1,1,0) ends with #value error.

Brent1946
Occasional Visitor

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 error. I have made cell formats all numbers with one decimal place. I have tried making the values text "". It still comes up with #VALUE. I have separated the formula's and they both work fine stand alone. Using the tracer it goes correctly to the second formula  and gives the correct result but still says #Value in C4????

1 Reply

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 

 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies