Search results

What I want for this formula to do/say/return is: If D5 is greater than 0 and E5 is greater than or equal to 2, then return the % earned based on the Qty in E5 in 25% increments. For example if the Qty in E5 is 2, that would equal 50%, 3 would equal 75%, etc. The Potential Bonus (column D) is...

=IF(A2='Call Out vs Off'!A2,COUNTIF('Call Out vs Off'!E2:Z2,"CALL OUT"),IF(A2='Call Out vs Off'!A3,COUNTIF('Call Out vs Off'!E3:Z3,"CALL OUT"),IF(A2='Call Out vs Off'!A4,COUNTIF('Call Out vs Off'!E4:Z4,"CALL OUT"),IF(A2='Call Out vs Off'!A5,COUNTIF('Call Out vs Off'!E5:Z5,"CALL OUT"),IF(A2='Call...