IF and IFS help needed

Iron Contributor

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

1 Reply

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


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.