Images based on input values.

Hi All, been looking around on the net for an answer to this. Have found some stuff thats close, but not getting me there.

I have an input for and one of the inputs it asks for is shaft diameter. The shaft diameter can range from .2 to 6.7. I also have 5 pictures and the spreadsheet needs to determine the proper picture (based on shaft Ø) and then display it. For example

If shaft Ø is .450, then show pic1.
If shaft Ø is 2.5, then show pic 3.

My initial attempt at this was to use a big if, then, else statement, but it did not work and I dont think its an efficient way to go about this anyway.

Here is part of what that looked like.

Please Login or Register  to view this content.

I need to test what interval "shaftval" falls into and then display the corresponding image for that value, and if shaftval isnt in that interval, then see if its in the next one.

Thanks.

Im thinking this may need to be done with an array, but havent got it working yet.

Any suggestions?