Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
The Formula is displaying, not the result | Excel Discussion (Misc queries) | |||
Formula Showing In A Cell Instead of Proper Result | New Users to Excel | |||
Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions |