IF and IFS help needed

[anupambit1797]

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 Welcome :)

Rule to calculate C10 is mentioned in the sheet.

Thanks & Regards

Anupam Shrivastava

[#2]

@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.