Thread: if command for yes or no
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default 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
Reply With QuoteReply With Quote