Forum Discussion

Patrick4704's avatar
Patrick4704
Copper Contributor
Apr 19, 2021
Solved

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 

 

Thanks 

 

pat 

excel

17 Replies

    • Patrick4704's avatar
      Patrick4704
      Copper Contributor
      Apr 20, 2021

      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 

Resources