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.
they are the same values but different devices
So the outcome of the formula doesn't depend on the device, does it?
- Hi Hans
No, it doesn't - I think I was over complicating it
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 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 I'd start by redoing the additional columns from left to right, that should be simpler than trying to edit the final formula.
- Cheers thanks again