Lookup - #N/A B2211 $5.20 98000 0.34 #N/A 104000 0.4 #N/A...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Lookup Tables Income Tax rate Lookup=D6:E9 0 0.15 10000 0.3 30000 0.34 100000 0.4 Lookup2=H11:I15 Product ID Price TRUE FALSE A134 $3.50 Income Rate B242 $4.20 -1000 #N/A #N/A X212 $4.80 30000 0.34 0.34 C413 $5.00 29000 0.3
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: #N/A B2211 $5.20 98000 0.34 #N/A 104000 0.4 #N/A ID Price B2211 3.5 B2211 5.2 A B C D E F G H I J 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22...
View Full Document

Ask a homework question - tutors are online