Help Formula displaying wrong value!

Hi All:

Thanks in advance for anyone that can help with this...

I have the following formula to display "Yes" if the following criteria is met..basically it is telling me if cell value Over and the percentage is Greater than 50% then, display yes, otherwise **, OR if value is "Under" and percentage is less than 50%. Now the cell that it is point to is in the following formula, even when it is Blank "***", I still get the value "Yes", and I can't figure out why...

=IF(OR(AND(NMast!$N81="Over", NMast!GK81>0.5), AND(NMast!$N81="Under", NMast!GK81<0.5)),"Yes","**")



The cell that is point to is this, I wonder if it's something to do with the "***", because when it is "***" my cell still display "Yes"

=IF(ISERROR(GH81/SUM(GH81:GI81)),"***",(GH81/SUM(GH81:GI81)))

Basically the 2nd formula is doing a very simple calcuatlion

example 1/0 is 100% if it is 0/0, then display ***

Please help, can't figure out why!!!

Thank You!!

"***" is NOT blank. It's a TEXT string of 3 * characters.
And > and < operators will consider Text Strings to be greater than Numbers.
So you'll have to add a test of the value actually being a number

Perhaps
=IF(ISNUMBER(NMast!GK81),IF(OR(AND(NMast!$N81="Over", NMast!GK81>0.5), AND(NMast!$N81="Under", NMast!GK81<0.5)),"Yes","**"),"**")

Thanks FDibbins!

And Thank You Jonmo1!!!

Your formula worked, can you explain to me what that formula is? I would like to fully understand the formula.

Also I have over like 60 formulas to change, I try to change from "***" to "" blank, it still doesn't work, it still display Yes, I
just don't understand why?
What kind of text or value / character or symbol can I put so it won't count as a value?

I just want to use it so it won't display blank, and it looks good on the spreadsheet..

Thank You so much!!!!!