Answered step by step
Verified Expert Solution
Link Copied!

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. image text in transcribed

image text in transcribed

- 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". - Save

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Audit Of Tax Regularity And Efficiency

Authors: Mohamed Aziz Boussaid

1st Edition

6206215865, 978-6206215868

More Books

Students also viewed these Accounting questions

Question

identify current issues relating to equal pay in organisations

Answered: 1 week ago