Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can anyone tell me what I did wrong in this formula? =IF(E4

Can anyone tell me what I did wrong in this formula?

=IF(E4<=10, "Good", IF(E4<=25, "Average", IF(E4>=26, "Critical")))

"Good" when the absolute value of difference is 10 minutes

"Average" when the absolute value of difference is 11 minutes but 25 minutes.

"Critical" when the absolute value of difference is 26 Minutes.

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

Essentials Of Forensic Accounting

Authors: Michael A Crain, William S Hopwood

2nd Edition

1948306441, 978-1948306447

More Books

Students also viewed these Accounting questions

Question

Get married, do not wait for me

Answered: 1 week ago

Question

Do not pay him, wait until I come

Answered: 1 week ago

Question

Do not get married, wait until I come, etc.

Answered: 1 week ago