Nesting IF, AND & ISTEXT Formulas

Hi,

I was wondering if anybody can help me with something that I can't seem to understand.

This is my formula: =IF(AND($N3="SUBMIT",$AR3="FALSE"),"Correct","Wrong")

Column N= Should be blank or have word submit in it
Column AR = this is a ISNUMBER calculation where it looks into another cell and just states true or false.

In this specific example N3=Submit and AR=FALSE but the calculation comes through as "wrong" when it should state correct.

When I evaluate the formula to see where it goes wrong, see the screenshot attachment, it gets stuck on cell AR3 when the cell value = the criteria I'm looking for.

I have also looked at formatting and it seems ok as the ISTEXT formula is providing the correct information.

Any help would be much appreciated.

R

Remove the quotes from around FALSE - that is a Boolean value, not a text string.

Hope this helps.

Pete

Works like a treat thanks very much guys. I thought it would have been something simple.