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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - When i put A in Cell A1 i need excellent to come up in B1 (https://www.excelbanter.com/excel-discussion-misc-queries/169700-when-i-put-cell-a1-i-need-excellent-come-up-b1.html)

Brad

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

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

chrissy

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

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

"brad" wrote:

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

Pete_UK

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

Put this formula in B1:

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

Hope this helps.

Pete

On Dec 14, 2:48 pm, brad wrote:
When i put A in Cell A1 i need excellent to come up in B1

All times are GMT +1. The time now is 05:55 PM.