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

SergeiBaklan

Diamond Contributor

Aug 20, 2020

fishdude

As variant

=IF(I12="trout",
   IF(M12>0,
     ((M12/100)^3)*10*0.105,
     0
   ),
 IF(I12="salmon",
   IF(M12>0,
     ((M12/100)^3)*10*0.9711,
      0.004*N12^2.535
   ),
 0))