More than one "if" in a cell
 

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?

More than one "if" in a cell
 

On 25 Feb., 14:26, Buggelsgaard
wrote:
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?

You can write an ordinary IF sentence another IF sentence within the
other.

Structu
=IF(IF(IF(x;x);x);x)

More than one "if" in a cell
 

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

More than one "if" in a cell
 

=IF(H7<1,0, IF(H739,D7+(F7*H7), C7+(E7*H7)))
or
=(H739)*(D7+(F7*H7))+(H7<39)*(H7=1)*(C7+(E7*H7))
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

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

More than one "if" in a cell
 

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

More than one "if" in a cell
 

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?

More than one "if" in a cell
 

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

No.2. works fine - thanks a lot.

/Buggelsgaard

"Bernard Liengme" skrev:

=IF(H7<1,0, IF(H739,D7+(F7*H7), C7+(E7*H7)))
or
=(H739)*(D7+(F7*H7))+(H7<39)*(H7=1)*(C7+(E7*H7))
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

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

More than one "if" in a cell
 

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?

More than one "if" in a cell
 

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

More than one "if" in a cell
 

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dave Peterson" wrote in message
...
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