When i put A in Cell A1 i need excellent to come up in B1

[brad]

When i put A in Cell A1 i need excellent to come up in B1

 

[Chrissy]

Write an if then statement if value in A1 +A, then "excellent"

 

[Pete_UK]

Put this formula in B1:

=IF(A1="A","excellent","")

Hope this helps.

Pete