Forum Discussion
How to format cells with multiple inputs if; and; or
hi i am trying to set up a spread sheet for testing electrical circuits, but with changeable values. I have attached a sheet which I have started, on but can not complete, can anyone help. Please ...
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.
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?
