False

[Geoff Whittaker]

I have the formula IF<50%,"NQ",IF>50%,"Q". When the formula shows up an exact 50% it shows "FALSE" any idea how I can overcome this problem.

 

[AliGW]

It doesn't account for exactly 50%, that's why. Try this:

IF<50%,"NQ",IF>=50%,"Q"

 

[vletm]

Geoff Whittaker
You should add needed result for case FALSE.
Now, it seems that You don't have it.
You would write Your formula here, then You would get more specific answer.

 

[Geoff Whittaker]

Thanks AliGW that sorted it. I realised I wasn't accounting for 50% but couldn't fathom my way around it. Great stuff.

 

[AliGW]

Glad to have helped!