Change content of one cell based on content of another Closed

Question

Hi! I'm looking for guidance on a formula/macro/etc that would enable me to have content of a cell changed based on the content of another cell in the same row.

Example: cell in column D says "PSA" - so I would need the cell in column H for that same row to read "Radio"

I would need an entire sheet scanned to review for these occurrences and make the appropriate changes. 

Any advice would be greatly appreciated. 

Thank you!

ac3mark · Answer

Ok, the format for IF is as follows:
=IF(logic_test,true, false)

So we would do this:
=IF(a1="PSA","RADIO","")

Put that is the cell you wish to display radio.

I hope that works, and I hope this isn't home work!

Change content of one cell based on content of another

1 response

Similar discussions

Subscribe To Our Newsletter!