Thread: My formula is =IF(B5="B",TODAY(),"")
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default My formula is =IF(B5="B",TODAY(),"")
Use the OR function.

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)

"Tredown" wrote in message
...
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.


Reply With QuoteReply With Quote