if command for yes or no

[Guest]

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]

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(I5>H5,"Y","N")


--ron

 

[Mladen_Dj]

In J5 enter formula:

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