show Image in formula using IF condition…

[VBABEGINER]

Dear All,

I want to show Image in formula using IF condition…

Can any one please help me in this..

=if(I1="AB",I:\New folder\Pic_AB.png,if(I1="AZ",I:\New folder\Pic_AZ.png))

Please revert....

 

[VBABEGINER]

Or else, I have used TextBox1 also...

Textbox1 is on Sheet1

Sheet2 I1 = "AB"

Area is the sheet, where I have kept data.

=IF(I1="AB","CO:-"&Area!B7,IF(Sheet!I2="AZ","CO:-"&Area!D8,IF(Sheet2!I2="Inter","CO:-"&Area!D17,IF(Sheet2!I2="SG","CO:-"&Area!D24,""))))