How to fill in a column based on another columns value?

Copper Contributor

I have an inventory list in Excel that I'm trying to configure to my liking. I'm looking for tips on how to make it so that if I write "Plenty" in column B for # in stock, an "N" will appear in column D for reorder Y/N in the corresponding row. Thanks in advance!Excel Q.png 

1 Reply


Perhaps in D5

=IF( $B5 = "Plenty", "N", "Y" )

and drag it down