Forum Discussion
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...
In Results!C2:
=LEFT(Computations!E3,FIND(" ",Computations!E3)-1)*IF(RIGHT(Computations!E3,4)="Gbps",1000,1)
Fill down.
In Results!C2:
=LEFT(Computations!E3,FIND(" ",Computations!E3)-1)*IF(RIGHT(Computations!E3,4)="Gbps",1000,1)
Fill down.
- Thank you very much.. this works great!
