| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
nested IF statements
I am trying to say - If c11 and d11 and e11 and f11 and g11 and h11 are
greater than zero then use the value in i11 if that value is less than or = to 8 if the value is in i11 ends up being greater than 8 then I need to put whatever is greater than 8 in a difference cell. Can someone help me get started? -- Thanks, Always learning all I can |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
nested IF statements
Try this:
=IF(AND(C110,D110,E110,F110,G110,H110),MIN(8 ,I11),"") will give a blank cell if any of those 6 cells are not greater than 0, but you can change the "" to some other value if you want to. I'm not sure what your conditions are for the different cell to take i11 if it is greater than 8 - is it still dependent on the 6 cells being greater than zero? Hope this helps. Pete On Aug 21, 11:34*pm, ssimer wrote: I am trying to say - If c11 and d11 and e11 and f11 and g11 and h11 are greater than zero then use the value in i11 if that value is less than or = to 8 if the value is in i11 ends up being greater than 8 then I need to put whatever is greater than 8 in a difference cell. Can someone help me get started? -- Thanks, Always learning all I can |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
nested IF statements
Thank you for the help. What I want is after this result is to take anything
greater than 8 and drop it in another cell but I think I can do that let's see what I get out of this first. -- Thanks, Always learning all I can "Pete_UK" wrote: Try this: =IF(AND(C110,D110,E110,F110,G110,H110),MIN(8 ,I11),"") will give a blank cell if any of those 6 cells are not greater than 0, but you can change the "" to some other value if you want to. I'm not sure what your conditions are for the different cell to take i11 if it is greater than 8 - is it still dependent on the 6 cells being greater than zero? Hope this helps. Pete On Aug 21, 11:34 pm, ssimer wrote: I am trying to say - If c11 and d11 and e11 and f11 and g11 and h11 are greater than zero then use the value in i11 if that value is less than or = to 8 if the value is in i11 ends up being greater than 8 then I need to put whatever is greater than 8 in a difference cell. Can someone help me get started? -- Thanks, Always learning all I can |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
nested IF statements
In your other cell you could use:
=MAX(0,i11 - cell_with_formula) which will give you zero or anything above 8 from i11. But, you may have to apply your 6 conditions as in the other formula. Hope this helps. Pete On Aug 22, 12:02*am, ssimer wrote: Thank you for the help. What I want is after this result is to take anything greater than 8 and drop it in another cell but I think I can do that let's see what I get out of this first. -- Thanks, Always learning all I can "Pete_UK" wrote: Try this: =IF(AND(C110,D110,E110,F110,G110,H110),MIN(8 ,I11),"") will give a blank cell if any of those 6 cells are not greater than 0, but you can change the "" to some other value if you want to. I'm not sure what your conditions are for the different cell to take i11 if it is greater than 8 - is it still dependent on the 6 cells being greater than zero? Hope this helps. Pete On Aug 21, 11:34 pm, ssimer wrote: I am trying to say - If c11 and d11 and e11 and f11 and g11 and h11 are greater than zero then use the value in i11 if that value is less than or = to 8 if the value is in i11 ends up being greater than 8 then I need to put whatever is greater than 8 in a difference cell. Can someone help me get started? -- Thanks, Always learning all I can- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NESTED IF STATEMENTS | New Users to Excel | |||
| Nested IF statements | New Users to Excel | |||
| Nested IF statements | Excel Discussion (Misc queries) | |||
| Nested IF statements | Excel Discussion (Misc queries) | |||
| Do I need nested IF statements? | Excel Worksheet Functions | |||
Hybrid Mode
