Forum Discussion

Copper Contributor

Aug 19, 2020

Combining multiple if(functions in one cell

Hi! So this one is a bit tricky. I'm trying to connect these three separate formulas into one cell: I got one formula which is - if this cell is salmon , and there is 1+ of them, choose this ce...

excel

Formulas and Functions

fishdude

Copper Contributor

Aug 19, 2020

fishdude

The logic In short:
IF A(salmon) and B(1), and either C(length) or D(height); use E formula*C if C present or F formula* D if D present. But if A(trout) and B(1), and C (length) use G formula*C