Answered step by step
Verified Expert Solution
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 #
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
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