thank you much apprecaited
--
ROD


"Jacob Skaria" wrote:

Try
=IF(A150%,"Yes","No")

'to handle blanks
=IF(A1,IF(A150%,"Yes","No"),"")

--
Jacob (MVP - Excel)


"Rod" wrote:

I am trying to write and IF Statement which will give me a "yes" if over 50%
and a "no" if under 50% for below table

Percent resolved
29%
38%
94%
67%
74%
63%
91%
81%

Many thanks
Rod