More than one "if" in a cell

[Buggelsgaard]

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?

 

[David Biddulph]

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

 

[Bernard Liengme]

=IF(H7<1,0, IF(H7>39,D7+(F7*H7), C7+(E7*H7)))
or
=(H7>39)*(D7+(F7*H7))+(H7<39)*(H7>=1)*(C7+(E7*H7))
best wishes

 

[Niek Otten]

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

 

[Buggelsgaard]

Hi David, this works - thanks a lot

/Buggelsgaard

"David Biddulph" skrev:

 

[Buggelsgaard]

No.1 doesn't give the correct result it gives a "false" result.

No.2. works fine - thanks a lot.

/Buggelsgaard

"Bernard Liengme" skrev:

 

[Buggelsgaard]

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:

 

[Dave Peterson]

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

 

[Niek Otten]

Always copy and paste formulas to your formula bar, never retype them

 

[David Biddulph]

No. 1 can not give a "false" result (or if it can, it would be interesting
to know what data values you have that give it). I assume that you have
tried to retype and mistyped. If you get a suggested formula in this group,
copy from here and paste into your formula bar; don't try to retype.