My formula is =IF(B5="B",TODAY(),"")

T

Tredown

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.
 
C

Chip Pearson

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)
 
Top