Returning a blank cell instead of VALUE

[Marvo]

Hi,

I have a formula

=IFS(C3="Northampton Town",D3>B3,1,"")

That works, returns TRUE or FALSE as a blank cell. I want the cell to return 1 instead of TRUE but when I add

=IFS(C3="Northampton Town",D3>B3,1,"")*1

I get the desired result but FALSE now shows as a VALUE error in other cells.

I'm guessing this is pretty simple to fix but don't know how.

Any help appreciated.

 

[Phuoc]

=IF(AND(C3="Northampton Town",D3>B3),1,"")

 

[Marvo]

Thank you so much, I thought it would be an easy one. Never got my head around AND or when and where to use it.