You may want to try those formulas again--even though you have a working
solution.

Buggelsgaard wrote:

Doesn't work correct - gives a "false" statement. Though I have found the
right solution by one of the other suggestions on this thread.

Thanks

/Buggelsgaard

"Niek Otten" skrev:

=IF(H7<1,0,IF(H739,D7+(F7*H7),C7+(E7*H7)))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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?



--

Dave Peterson