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

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

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

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 -