Change content of one cell based on content of another [Closed]

Report
Posts
1
Registration date
Friday April 18, 2014
Status
Member
Last seen
April 18, 2014
-
 Blocked Profile -
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!

1 reply


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!