Scribd
Upload
11 views2 pages

1.1 IF and Vlookup

The document presents a dataset of transactions including details such as Transaction ID, Date, Product, Quantity, and Price per Unit. It outlines tasks to create new columns for Total Sales and Net Sale, applying a discount based on quantity sold. Additionally, it specifies a requirement to display transaction details based on a given Transaction ID.

Uploaded by

CYBERDAKWAH
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
11 views2 pages

1.1 IF and Vlookup

The document presents a dataset of transactions including details such as Transaction ID, Date, Product, Quantity, and Price per Unit. It outlines tasks to create new columns for Total Sales and Net Sale, applying a discount based on quantity sold. Additionally, it specifies a requirement to display transaction details based on a given Transaction ID.

Uploaded by

CYBERDAKWAH
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/ 2

Transaction ID Date Product Quantity Price per Unit

SR2001 1/1/2024 Laptop 5 1000


SR2002 1/2/2024 Smartphone 10 500
SR2003 1/3/2024 Printer 2 200
SR2004 1/4/2024 Tablet 8 300
SR2005 1/5/2024 Desktop 3 1200
SR2006 1/6/2024 Headphones 15 50
SR2007 1/7/2024 Laptop 3 1000
SR2008 1/8/2024 Smartphone 5 500
SR2009 1/9/2024 Tablet 10 300
SR2010 1/10/2024 Printer 4 200
SR2011 1/11/2024 Desktop 2 1200
SR2012 1/12/2024 Headphones 8 50
SR2013 1/13/2024 Smartphone 7 500
SR2014 1/14/2024 Laptop 4 1000
SR2015 1/15/2024 Tablet 6 300
SR2016 1/16/2024 Desktop 5 1200
SR2017 1/17/2024 Headphones 12 50
SR2018 1/18/2024 Printer 3 200
SR2019 1/19/2024 Laptop 6 1000
SR2020 1/20/2024 Smartphone 8 500

Question

1 In the dataset, create a new column named "Total Sales" which calculates the total sales for each transactio
2 Add another column, "Net Sale," needs to be added. Apply a 10% discount for total sales ,if the total quanti
3 If I enter transaction ID , the associated data should appear in the table
Transaction ID
Date
Product
Quantity
Price per Unit

s the total sales for each transaction (Quantity * Price per Unit).
nt for total sales ,if the total quantity sold is Equal or greater than 5; otherwise, keep the original price.

You might also like