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.
You 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?
Thanks. Am I correct in understanding that the device doesn't matter, only the type and rating?
- No, it will depend on if what is typed into the cell for the device whatever it will be either MCB or RCBO.
