How to combine multiple formulas in 1 cell

Question

I am trying to combine the below two formulas in one cell, but no luck so far.

Both formulas work OK on their own, but I can not figure out how to combine them together to produce the result in same cell.

=IF(AND(C18>0, C6>J11), J11, C6) 

=IF(AND(C17<K5, C6>J10), J10, C6)

Solution

You can nest functions inside each other, I think this is the one you need:

=IF(AND(C18>0, C6>J11), J11, IF(AND(C17 <K5, C6>J10), J10, C6))

Comments

[GovVek]

Wow, it worked perfect. I see where I was going wrong. Than you very much for your help.

[ejbytes]

@GovVek Please don't forget to click in the Check Mark to mark it as accepted answer. Welcome to SuperUser!