Hi David, this works - thanks a lot

/Buggelsgaard

"David Biddulph" skrev:

=IF(H7<1,0,IF(H7<=39,C7+E7*H7,D7+F7*H7))
--
David Biddulph


"Buggelsgaard" wrote in message
...
I would like to put all these functions into one cell:
IF H7 is less than 1, then the result is 0.
IF H7 is 1-39, then the result is C7+(E7*H7).
IF H7 is more than 39, then the result is D7+(F7*H7).

How would this formula be created?