How to change image by function?

  • Thread starter Thread starter K.Parker
  • Start date Start date
K

K.Parker

Dear all,

I found that the paste picture link feature is useful. Can I create a link picture that can be
change by function?
Like =IF(A1="USA","show a cell's link","nothing")
If the cell A1 is USA, the picture link will show the content of B1 to C1, if not, show nothing?

Thanks for your help.

K.Parker
 
I think you would have to make B1 to C1 not show anything. The picture link
reflects the linked worksheet. As far as I know you can't edit the linking
formulas if formulas are used (which i doubt).
 
Back
Top