ExcelBanter - IF Statement Yes/No

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF Statement Yes/No (https://www.excelbanter.com/excel-discussion-misc-queries/264537-if-statement-yes-no.html)

Rod

IF Statement Yes/No

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

Rod

IF Statement Yes/No

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

Jacob Skaria

IF Statement Yes/No

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

All times are GMT +1. The time now is 02:12 PM.