Doh! Why didn't I think of that??? That's Bill - much appreciated.


Regards,



Gavin





"Bill Kuunders" wrote in message
...
You have already got it.
not blank, not smaller than 40 and not larger than130 ...........
i.e. in stead of "0" at the end , enter what ever factor you need.

Regards
Greetings from New Zealand
Bill K

"gavin" wrote in message
...
I have the following formula which works OK:

=IF(ISBLANK(AJ2),"",IF(H2<40,'Jobs (2)'!F2*0.682,IF(H2130,'Jobs
(2)'!F2*0.781,"0")))

But I need to add another IF clause to account for values in H2 which
lie
between 40 and 130. How do I do that - I just can't work it out?