ExcelBanter - if command for yes or no

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - if command for yes or no (https://www.excelbanter.com/excel-worksheet-functions/55609-if-command-yes-no.html)

Henry

if command for yes or no

how can I get a worksheet to answer Y or N for a column.
For example column I5 is greater then H5 i want a Y or N on column J5.
Any help?

Ron Rosenfeld

if command for yes or no

On Tue, 15 Nov 2005 11:26:11 -0800, "Henry"
wrote:

how can I get a worksheet to answer Y or N for a column.
For example column I5 is greater then H5 i want a Y or N on column J5.
Any help?

=IF(I5H5,"Y","N")

--ron

Mladen_Dj

if command for yes or no

In J5 enter formula:

=if(I5H5,"Y","N")

"Henry" wrote in message
...
how can I get a worksheet to answer Y or N for a column.
For example column I5 is greater then H5 i want a Y or N on column J5.
Any help?

All times are GMT +1. The time now is 03:44 AM.