View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default My formula is =IF(B5="B",TODAY(),"")

=IF(OR(B5={"B","R"}),TODAY(),"")


"Tredown" wrote:

The formula works fine if the cell contains the Letter B but I would like to
have the same result if I typed B or R . I am not sure if I could nest this
into the formula.