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