Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help finding the formula for this problem on Excel. I am pretty sure it is an =IF(OR. function but am not 100%. I
I need help finding the formula for this problem on Excel. I am pretty sure it is an =IF(OR. function but am not 100%. I will post the instructions and picture of workbook page.
- Place a function in cell G2 to: - Display "Detail Audit" - If the Order Amount is greater than $20,000, or - The Item ID is MDRSHRT and the Order Amount is greater than $10,000, Display "Verify Invoice Amount" - If the Order Amount is greater than or equal to $16,000 or the item is "WDRESS"; - All others display "OK". - SaveStep 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