if command for yes or no

H

Henry

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?
 
R

Ron Rosenfeld

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?
Click to expand...

=IF(I5>H5,"Y","N")


--ron
 
Top