Thread: Yes/No Function
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] omnicrondelicious@gmail.com is offline
external usenet poster
 
Posts: 23
Default Yes/No Function

You just gave the formula! ;) In cell J1, enter =IF(H1I1,"Yes","No")


On Apr 9, 9:22 am, dn5580 wrote:
Looking to get a formula for the following scenerio:

if H1 is greater than I1, then J1 is "Yes" and of not J1 is "No"