Change content of one cell based on content of another

Closed
stlellen Posts 1 Registration date Friday April 18, 2014 Status Member Last seen April 18, 2014 - Apr 18, 2014 at 02:12 PM
 Blocked Profile - Apr 18, 2014 at 03:16 PM
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

Blocked Profile
Apr 18, 2014 at 03:16 PM
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!
0