Enter a formula with an IF function so if the customer\'s state is NV (Nevada),
ID: 3706738 • Letter: E
Question
Enter a formula with an IF function so if the customer's state is NV (Nevada), then calculate 6.85% of the subtotal; otherwise use 0 for the sales tax.
The defined name "State" is assigned to the cell C12 (where you type in the state's initials) and the defined name "Sub_Total" is defined to the cell H27.
I'm unsure on how to change the test so that the State cell has to equal NV in order to qualify for the 6.85% of the subtotal. What am I doing wrong?
The problem is Case Problem 1 from Module 8 of the Microsoft Office 365 Excel 2016 book, on page EX 524.
Function Arguments IF Logical_test Statel Value_if_true Sub_Total*0.00685 Value if false 0 0.37675 Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE. Logical_ test is any value or expression that can be evaluated to TRUE or FALSE.Explanation / Answer
Solution:
The correct IF statement will be
=IF(C12>="NV", H27*6.85%, 0)
This will work
I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.