I've entered the following formula into my worksheet:

=IF(AND(ISNA(B891),LEFT(I890,1)="i",I892=0),"BLARGH","Blech")
In the Function Arguments window it gives me the correct result of Blech, however in the actual cell it's giving me a 0. Before you respond let's go down the list of things I've tried:

-The CTRL+` method
-The replace all = sign method
-The copy paste special add (and multiply) method
-The close and open method
-The copy pasta

I don't know what else to do or how to fix it, I'm sure I tried more (or at least felt like it) but I'm starting to forget what else I tried. If anyone has any ideas please let me know.