If FALSE, leave cell blank - help please -- ("" doesn't work?)

[aiki100]

Greetings all -


I have looked high and low for this, both here and elsewhere on the net, and I am missing something I am sure that must indeed be so simple...I hope someone can help with this, thanks!




This formula below, works fine:




=IF(AND(AJ2="x",AL2="L"),J3-AR2,IF(AND(AJ2="x",AL2="S"),AR2-J3))




In the event the AND conditions are not met, the formula returns FALSE, as it should. I simply want to suppress the FALSE, and leave the cell bank so I don't have to look at it.




I have tried various versions of "", (which work every place else I've ever used them), but there is something I don't understand about what is gong on here.




Thank you so much for the help, it is very much appreciated!


Aiki

 

[aiki100]

Thanks so much for the try - you've been really great.

The line spacing was just me trying to make things easier to see - I will try to clean it up.


Have a super week, and thank you again!