I've got a function which I need a little help on please:
I'm currently using:
but need to use something along the lines of:
=IF((AND($G19 [does not equal "NA"] ,$G19>94.5%)),$G19,NA())
How do I code the part in square brakets, ie a value does not equal?
What I'm finding currently is that with a
singular $G19>94.5% function, the cells with an NA text value are being copied across as a 100% value rather than #NA.