Forum Discussion
How to format cells with multiple inputs if; and; or
See the attached version. I left in columns N to P with some intermediate results that I used to create the formula in column M.
What is the problem? Why do you think the result in M11 is not correct?
Hi Hans thank you for taken the time to have a look at this, the issue is that the values in roe E & F is different and has different set characteristics and therefor if the readings in roe I is greater than a set value pending on which type and what ampage it is it fails so not all MCB`s and RCBO`s are the same HansVogelaar
Thanks again
I'm afraid you'll have to explain in much more detail what you want the formula to do...
- Hi Hans in roes D i need to be able to change the Protective device to either Mcb or RCBO; in roe E i need to be able to change roe for a range of 6 to 100 these are Amps; in roe C i need to be able to change this to either B, C, or D; in Colum I the values changes ie. if I have a MCB and it type is B and the maximum set value for this is 2.6 say, if the reading that is imputed in this cell (I) is higher this is a fail. I need to be able to change the cells from D,E &,F, and pending on the set values of the type of device and its rating and also it Type(B,C, or D) as you see if i chance the cell E10 to a 20 and cell F10 ifs a fail because the set values will be different in Roe I.
Not sure if i am making sense, I kind a know its is a lot of code but unsure how to expand from what i have done in roe I-10
=IF(AND(D10="MCB",F10="B",E10=10,I10<=1.68),"Pass","Fail")
ThanksYou will have to use a list that specifies the limit for each protective device, each rating and each type. Do you already have such a list? If so, what does it look like?
