I am trying to build a formula that will give me a certain Percentage based on the the numbers in the fields. Here is the example using Row 3 and columns C, D & E. info in the worksheet: C3 = 4 D3 = 3 & E3 =2
C3 D3 E3
4 3 2
Here is the criteria. If D3> C3 give the percentage of E3/C3, If D3< C3 give the percentage of E3/D3.
I want it to reflect the result as a Percentage ie 67%. The other thing I need to be able to do is I am doing this in different workbooks. So the page of workbook 1 is where I want the result displayed, but the information is gathered from a page in Workbook 2. Any help would be greatly appreciated.
GMan 62
C3 D3 E3
4 3 2
Here is the criteria. If D3> C3 give the percentage of E3/C3, If D3< C3 give the percentage of E3/D3.
I want it to reflect the result as a Percentage ie 67%. The other thing I need to be able to do is I am doing this in different workbooks. So the page of workbook 1 is where I want the result displayed, but the information is gathered from a page in Workbook 2. Any help would be greatly appreciated.
GMan 62