Forum Discussion
Patrick4704
Apr 19, 2021Copper Contributor
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 ...
- Apr 20, 2021
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.
Patrick4704
Copper Contributor
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
Thanks a million
HansVogelaar
Apr 20, 2021MVP
I'd start by redoing the additional columns from left to right, that should be simpler than trying to edit the final formula.
- Patrick4704Apr 20, 2021Copper ContributorCheers thanks again