Question: I have a question on Excel spreadsheet functions Given C2=85 and a If function = IF (C2 <75,100,IF(C2>100,80,90)) Based on the logic of this condition,

I have a question on Excel spreadsheet functions

Given C2=85 and a If function

= IF (C2<75,100,IF(C2>100,80,90))

Based on the logic of this condition, in English, it says if C2 is less than 75, take 100 otherwise

check if C2 is greater than 100, if so take 80 otherwise take 90.

Accordingly my answer is 90 but it was incorrect. What wrong with my logic?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

the expected population exception rate (EPER) was specified as 1% or 2%, the tolerable exception rate (TER) was specified as 7% or 8%, and the acceptable risk of overreliance (ARO) was specified as...

Q:

ID Salary 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 65.1 27 36.1 61.4 46.6 73.3 39.7 23.2 74.6 22.8 23.4 62 40.7 23 24 51.1...

Q:

This case will use an Excel Workbook as a Tutorial Tool (with learning content incorprated into each worksheet). Within the Workbook there will be multiple worksheets that the student will need to...

Q:

1. What are the advantages and disadvantages of Rosetta Stone going public? 2. What do you think the current value of a share of Rosetta Stone is (at the time of the case)? Justify your valuation on...

Q:

. What are the advantages and disadvantages of Rosetta Stone going public? 2. What do you think the current value of a share of Rosetta Stone is (at the time of the case)? Justify your valuation on a...

Q:

Simple Linear Romanian Brey's Accounting & Tax Services is a small accounting fim in Sioux City, I which completes taxes for individuals. Hvery yow, firms like Bret's decide how much they will charge...

Q:

Please see attachment. All three question need to be answered in narrative format. If you have questions, just let me know. Normal requirement for references are 2 outside our course text....

Q:

PLEASE COMPLETE NO LATER THAN 10/07 @8:00AM Each question(1,2,& 3) must be a minimum of 200 words. Please make answers detailed and knowledgeable based off the attached reading. ARE YOU ABLE TO...

Q:

Drive (miles) 4 6 6 20 25 25 28 29 33 36 36 36 36 36 40 42 42 54 54 55 63 63 71 71 73 76 76 76 78 80 80 80 80 88 94 State MI SC OR MI GA CA NY TX SC TX CA MI TX OR IL FL IL FL NY OH PA OR MI MI FL NY...

Q:

Lecture Notes DL MGT 5100 - Distribution Management Spring 2017 1.0. Day one, Monday, Monday, 9 Jan 17 1.1. Reading Assignments: Chapters 1 and 2 1.1.1. I intend to follow the book so as to provide a...

Q:

Lecture Notes DL MGT 5100 - Distribution Management Spring 2017 1.0. Day one, Monday, Monday, 9 Jan 17 1.1. Reading Assignments: Chapters 1 and 2 1.1.1. I intend to follow the book so as to provide a...

Q:

On January 1, 2017, Dirt Company acquired all of Cat Company's voting stock for $16,000 in cash. Some of Cats identifiable assets at the date of acquisition had fair values that are different from...

Q:

These problems are available in MyFinanceLab. Miles heard about a fantastic restaurant chain that is issuing an initial public offering (IPO), so he took Dollie to try one of the nearby restaurants....

Q:

Gema is paid for each blouse she sews at the clothing factory. What type of pay does she receive? Multiple Choice overtime rate commission hourly wage piecework rate salary

Q:

2 5 Cent, a hip hop star, was on the public beach at Hilton Head when a spy photographer for The National Enquirer took a photo of a tattoo on his back that said I love Imagine Dragons! The National...

Q:

2. Most scalping laws make it illegal to sellbut not to buy tickets at prices above those printed on the tickets. Assuming that is the case, use supply and demand analysis to explain why the...

Q:

4. What are the determinants of supply? What happens to the supply curve when any of these determinants change? Distinguish between a change in supply and a change in the quantity supplied, noting...

Q:

3. Explain the law of supply. Why does the supply curve slope upward? How is the market supply curve derived from the supply curves of individual producers? LO3.3