Nested IF Functions

Hi JB,

I was out all day today, looking over what you have done, I have noticed that if the value entered in E2 is less than 1500 N/A appears on page 2 all the way down the list of parts?

I have had a look and cannot figure out why.

any chance you can look at it for me

cheers

ps i see where you are having to *0.001; I have changed vaule's too MM now
this is not the reason for the N/a I started checking this with the 1.75 etc on sheet 5