Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Find the price for each item charged to the customer in cell E 5 based on whether they receive a discount using an IF statement.
Find the price for each item charged to the customer in cell E based on whether they receive a discount using an IF statement.
How it is supposed to work:
Price status can only be "Regular" or "Discount".
When the Price status is "Regular" the Priced is equal to the Regular Price.
When the Price status is "Discount" the Price is equal to the Discount Price.
Excel File with Regular Price in B$ Discount Price in B$ Customer ID in E digit number Price in ERegular Quantity in E Price in Eblank and Total in Eblank
Create the IF statement below:
IF Answer
Answer
Answer
Can you create the IF statement in Excel without looking at the dropdown menu?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started