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.
Thanks. Am I correct in understanding that the device doesn't matter, only the type and rating?
- Cheers thanks again
I'd start by redoing the additional columns from left to right, that should be simpler than trying to edit the final formula.
- you are a genus; cheers for that, I will need to change it to put it into a different template i have done all ready, i should be able to back trace from the sheet you done, is there any particular order i should work from.
Thanks a million 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.
- I think I was over complicating it
- Hi Hans
No, it doesn't So the outcome of the formula doesn't depend on the device, does it?
- they are the same values but different devices
- No, it will depend on if what is typed into the cell for the device whatever it will be either MCB or RCBO.
