if formula

[adrian335i]

hey im trying to figure out how to do comp worksheet for payout th formula im working on is =IF(N8>70,"",N8*LOOKUP(N8,{5,6,7,9,11,15,20,28,34,41},{70,78.999,88.999,98.999,109.999,122.999,142.999,169.999,190.999,210.999}))N8 is the total saled MTD thanks REP GRID Points Range Rep. Award0 to 69 $- 70 to 78 $5.00 79 to 88 $6.00 89 to 98 $7.00 99 to 109 $9.00 110 to 122 $11.00 123 to 142 $15.00 143 to 169 $20.00 170 to 190 $28.00 191 to 211 $34.00 211 to $41.00

 

[Jonmo1]

Looks like you have the 2 arrays reversed...

The array{70,78.99,88.999...} should come first in the lookup, then the {5,6,7...}

Also, you need to change > to <

> means Greater Than
< means Less Than