I did some looking but did not find anything matching my problem so I will do a new post. I am looking to calculate First Pass Yield and need some help in getting defaults values to enter a cell when not failures occur. Data is as follows:
A1=100
B1=25
I know that if I place the formula in cell C1 as follows (B1/A1) comes to a value of 25 (or 25% if cell is formatted to %). I also need to know how to get the formula to also subract the 25 from A1 to give me the yield number. if anyone knows how this can be accomplished I would be grateful.
Shane
A1=100
B1=25
I know that if I place the formula in cell C1 as follows (B1/A1) comes to a value of 25 (or 25% if cell is formatted to %). I also need to know how to get the formula to also subract the 25 from A1 to give me the yield number. if anyone knows how this can be accomplished I would be grateful.
Shane