Forum Discussion

JoseP1504's avatar
JoseP1504
Copper Contributor
Mar 27, 2023
Solved

How to formulate different circuit sizes into one answer.

Alcon,  (See Sample attached) I currently have an excel sheet which pulls a report results into Input sheet. Then formulas within Computations sheet is used to find the correct circuit information...
excel
Formulas and Functions
Macros and VBA
  • HansVogelaar's avatar
    HansVogelaar
    Mar 27, 2023

    JoseP1504 

    In Results!C2:

     

    =LEFT(Computations!E3,FIND(" ",Computations!E3)-1)*IF(RIGHT(Computations!E3,4)="Gbps",1000,1)

     

    Fill down.

HansVogelaar's avatar
HansVogelaar
MVP
Mar 27, 2023

JoseP1504 

In Results!C2:

 

=LEFT(Computations!E3,FIND(" ",Computations!E3)-1)*IF(RIGHT(Computations!E3,4)="Gbps",1000,1)

 

Fill down.

JoseP1504's avatar
JoseP1504
Copper Contributor
Mar 27, 2023
Thank you very much.. this works great!