View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mladen_Dj
 
Posts: n/a
Default 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?