nested IF statements

[ssimer]

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?

 

[Pete_UK]

Try this:

=IF(AND(C11>0,D11>0,E11>0,F11>0,G11>0,H11>0),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

 

[ssimer]

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

Try this:

=IF(AND(C11>0,D11>0,E11>0,F11>0,G11>0,H11>0),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

 

[Pete_UK]

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