Custom Rounding And IF Statement In One Formula....

Originally Posted by shg

Missing a pair of parens:

=CHOOSE(MATCH(INT(A1) + LOOKUP(ROUND(MOD(A1,1), 6), {0,4,8}/10, {0,5,10}/10), {0,3.5,7.5}), 2 * (INT(A1) + LOOKUP(ROUND(MOD(A1,1), 6), {0,4,8}/10, {0,5,10}/10)), 6, 8)

THAT WORKED!

Again, you saved my day as I need this spreadsheet for work by Monday morning and I got everything else working perfectly except this part was a little beyond me.

THANK You both for your help!