S
sharkman
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
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