how can i insert a picture with formulas?

[Hiramsg]

I have a workbook and i want to insert a picture in a specific cell when
some value is in other celll, how can i do that?the picture is located in the
same workbook but in another sheet.

thanks hiram