[go: up one dir, main page]
Scribd
Upload
6 views4 pages

Comp

The document contains a list of products with their respective quantities, unit prices, subtotals, discounts, and VAT calculations. It also includes discount thresholds and VAT rates. Additionally, there is a summary of total costs for various items categorized as hardware and accessories, along with their delivery statuses.

Uploaded by

simplybyfiona
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
6 views4 pages

Comp

The document contains a list of products with their respective quantities, unit prices, subtotals, discounts, and VAT calculations. It also includes discount thresholds and VAT rates. Additionally, there is a summary of total costs for various items categorized as hardware and accessories, along with their delivery statuses.

Uploaded by

simplybyfiona
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 4

A (ProductB ID)

(Product Name)
C (Quantity)D (Unit Price) E (Subtotal) F (Discount) G (VAT 12%)
P001 Office Chair 3 1500 =C2*D$2 #VALUE! 540
P002 Desk Lamp 5 850 4250 425 510
P003 Filing Cabinet 2 3200 6400 640 768
P004 Whiteboard 4 1100 4400 440 528
P005 Office Table 1 5500 5500 550 660

Cell Label Value


Discount
c10 1000
Threshold
Discount
c11 0.1
High
Discount
c12 0.05
Low
c13 VAT Rate 0.12

price quantitity
1 1500 3
2 850 5
3 3200 2
4 1100 4
5 5500 1
H (Total Cost)
#VALUE!
4335
6528
4488
5610
Item Produ Quanti Total Trimmed Characte
Unit Price Category Status
Code ct ty Cost Product r Count
P001 Mouse 10 250 Hardware Delivered 2500 Mouse 4
Keybo
P002 8 500 Hardware Pending 4000 Keyboard 4
ard
Monit
P003 4 4500 Hardware Delivered 18000 Monitor 4
or
USB USB
P004 20 100 Accessory Cancelled 2000 4
Cable
Printer Cable
Printer
P005 5 850 Accessory Delivered 4250 4
Ink
Headp Ink
Headpho
P006 7 1200 Accessory Pending 8400 4
hones nes
20 1233.333 3 3 39150 24
4
VLOOKUP

250
500
250
100
850
1200

You might also like