Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 8 2 pts Write the function that will check cell A10. If A10 is greater than or equal to B10, it will compute and

image text in transcribed
Question 8 2 pts Write the function that will check cell A10. If A10 is greater than or equal to B10, it will compute and display B10/B4. But if not, it will compute and display B10/B5. =IF(A10>=B10,110/A10,110/A10) =IF(A10>=B10, B10/B4,B10/B5) =IF(A10>=B10,B10/B5,310/B4) =IF(A10>=B10, B10/B4,B5) Question 9 2 pts Write the function that will check cell A10. If A10 is less than or equal to B11, it will compute and display B11/B4. But if not, it will compute and display B11/B5. =IF(A10B11,810/B4,B5) =IF(A10>-B11,011/B5,B11/B4) =IF(A10

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

Step: 3

blur-text-image

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

Financial And Managerial Accounting For MBAs

Authors: Peter D. Easton, John J. Wild, Robert F. Halsey, Mary Lea McAnally

5th Edition

1618532324, 9781618532329

More Books

Students also viewed these Accounting questions