Result of Formula produces Picture?
 

Here is what I am wanting to accomplish:
I have a spreadsheet with manually inputted values, lets say the number
represents a credit score. I then want to have a function that
recognizes the number, within a set range, and then because of the
value an image/jpg/gif/bmp is pulled up on a different Sheet of the
spreadsheet.

For example:
If the credit score is 500, then the formula would pull up and display
the image 'score500.jpg'. If the score was 600, image 'score600.jpg'
would be displayed.

Hope that makes sense. I have the formula part down for the IF section
of it, even got hyperlinks to work as well, but I want the image to
show, not a link to it.

Any one got the solution?

Thanks!
Jason


--
sharkman
------------------------------------------------------------------------
sharkman's Profile: http://www.excelforum.com/member.php...o&userid=34819
View this thread: http://www.excelforum.com/showthread...hreadid=545751

Result of Formula produces Picture?
 

Someone would have to write you some vb code, but it would be better for
you if you included the current formulas and places you want the
pictures to appear as they would be part of the code. It is unclear at
the moment

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=545751

Result of Formula produces Picture?
 

So here is the formula that I have so far:
=IF(E15=700,"SUPER DUDE",IF(E15=600,"EXCELLENT",IF(E15=500,"GOOD
JOB",IF(E15=400,"BAD JOB"))))

Basically in the quotes I would want it to pull up a certain image,
different for each part of the IF statement.

Thanks!
Jason


--
sharkman
------------------------------------------------------------------------
sharkman's Profile: http://www.excelforum.com/member.php...o&userid=34819
View this thread: http://www.excelforum.com/showthread...hreadid=545751

Result of Formula produces Picture?
 

Anyone got any ideas on how I could do this, or where I could turn? I
have a marketing piece that I want to send out next week, and I would
love for it to be integrated with the information in the spreadsheet.

Thanks!
Jason


--
sharkman
------------------------------------------------------------------------
sharkman's Profile: http://www.excelforum.com/member.php...o&userid=34819
View this thread: http://www.excelforum.com/showthread...hreadid=545751