Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Apr 10, 2023

IF and IFS help needed

Dear Experts,                     I need your help to calculate the Value in C10, in the attached sheet using both IF(method-1) and IFS(Method-2) also if any other methods/formulae more than Welcom...
Formulas and Functions
mtarler's avatar
mtarler
Silver Contributor
Apr 11, 2023

anupambit1797  OK first you have to assign those drop down menus to a cell.  I assigned each to the cell they are on top of.  Then I use the following simple IF statement:

=IF(C2=2,1+(C4<3)*(C6<2),MIN(1+(C8>1)*(C4=1)*(C6=1)+(C8=1),2))

Basically I converted a lot the sub IF parts into a mathematical equivalent and only used the IF at the very top level (but you could replace that with a mathematical equivalent also and have no IF in the equation at all.

BTW is this homework?  If it is, I hope this helps you have ideas and thoughts but I'm not sure a professor will think this is actually your work.  If this is for other purposes I hope it works for you.  Let me know if you have any questions.

 

Resources