LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sharkman
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
The Formula is displaying, not the result tcarp Excel Discussion (Misc queries) 6 January 30th 07 06:51 AM
Formula Showing In A Cell Instead of Proper Result DanK New Users to Excel 2 March 4th 06 06:46 AM
Median result used in formula gives incorrect result vlatham Excel Worksheet Functions 4 September 21st 05 04:26 PM
Is there a formula to spell out a number in excel? Sha-nay-nay Excel Worksheet Functions 2 December 18th 04 09:25 PM
Convert Numeric into Text Monty Excel Worksheet Functions 0 December 18th 04 09:25 PM


All times are GMT +1. The time now is 07:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"