Nested If Formula

Column A Total
Column B Current %
Column C Total Time
Column D Criteria 0-1.99 = 10%, 2-4.99 = 15%, 5-8.99 = 20% and >8.99 = 25%

My formula looks at Current % (in Column B) and Total Time (in Column C) Based on the following criteria: 0-1.99 = 10%, 2-4.99 = 15%, 5-8.99 = 20% and >8.99 = 25%. When comparing Total Time in Column C to the Criteria outlined in Column D the result should be the same as Column B, if the current exceeds the criteria, if not then the result should return a result based on the criteria. My formula returns the correct result if the Current % exceeds my critera But returns TRUE instead of the Criteria %.

=IF(B3>IF(C3<=1.99,10%,IF(AND(C3>1.99,C3<=4.99),15%,IF(AND(C3>4.99,C3<=8.99),20%,25%))),B3,IDC3<IF(C3<=1.99,10%,IF(AND(C3>1.99,C3<=4.99),15%,IF(AND(C3>4.99,C3<=8.99),20%,25%))))

I'm not sure if I completely understand what you're trying to accomplish, but I think the problem is with one of the last If statements. Try using the code below in row 3 and copy it down and see if it works as expected. All I did was removed the "IDC4<" part of the formula.

Please Login or Register  to view this content.

Snax....it worked...my issue is Solved Thank You for your quick response!