How to Combine Multiple Formulas in 1 Cell
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...
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)
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))
Another way to combine multiple formulas, but for a different purpose:
=SUBSTITUTE(SUBSTITUTE(A1,"a","e"),"oo","o")
It also works in Google Sheets.
James Sterling reports on renewable energy developments, climate policy, ecological conservation, and green tech innovations around the globe.
