Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given the spreadsheet as show in the picture below, answer the following question. B C D E F G H 2 3 Invoice #

image text in transcribed

Given the spreadsheet as show in the picture below, answer the following question. B C D E F G H 2 3 Invoice # Province Date Invoice Amt Days Outstanding Message 4 3436 AB 44020 252.13 101 5 3437 BC 44025 233.57 96 6 3438 AB 44025 127.61 96 7 3439 AB 44032 296.37 89 8 3440 BC 44033 201.21 88 9 3441 SK 44046 124.13 75 10 3442 AB 44048 236.14 73 11 3443 SK 44050 133.71 71 12 3444 BC 44060 341.09 61 13 3445 BC 44065 104.82 56 14 3446 BC 44066 189.2 55 15 3447 SK 44070 322.78 51 16 3448 AB 44078 155.71 43 17 3449 AB 44090 300.84 31 18 3450 SK 44091 230.57 30 19 3451 BC 44100 258.93 21 20 3452 BC 44110 218.76 11 21 3453 BC 44117 242.53 4 22 3454 BC 44119 135.87 2 Days Message 0 30 Delayed 60 Overdue Create a formula in Cell F4 that displays a warning message. There are three possible messages and conditions that should be used to determine which message needs to be displayed (H4:16). For all Days Outstanding that are less then equal to 30, display "OK". For all Days Outstanding that are less then equal to 60 and greater than 30, display "Delayed". For all others, display "Overdue". Which of the formulas would correctly display a message?

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

Financial Accounting in an Economic Context

Authors: Jamie Pratt

9th edition

9781118803035, 1118582551, 1118803035, 978-1118582558

More Books

Students also viewed these Accounting questions