| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| "CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Linear Mode
