Question: I need help figuring out they are correct or not!! Responses: A = Correct =IF(C10>=100,50,50) =IF(C10=>100,0,50) =MAX(A11:A1000) =IF(MONTH(C30)=12,0,.1) =PMT(.08,1000) =IF(WEEKDAY(G10)=1,100,0) B = Correct but meaningless

I need help figuring out they are correct or not!!

I need help figuring out they are correct or

Responses: A = Correct =IF(C10>=100,50,50) =IF(C10=>100,0,50) =MAX(A11:A1000) =IF(MONTH(C30)=12,0,.1) =PMT(.08,1000) =IF(WEEKDAY(G10)=1,100,0) B = Correct but meaningless C = Incorrect =A12*(1+$B$2) =FV(.05/12,10*12,-1500) =FV(.08,9,30,000) =PMT(0.08/12,3*12,-24000) =PMT(A10/12,A11*12,-A12) =IF(WEEKDAY(B10)=12,"OK","INVALID") =IF(C10 = M, 50,0)

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 General Management Questions!

Elsa's Boards sells a snowboard, Xpert, that is popular with snowboard enthusiasts. Information relating to Elsa's purchases of Xpert snowboards during September is shown below. During the same...

Internal controls are methods and strategies used to keep information and inventory safe from theft and to easily tell if something is compromised or missing. In this assignment, you will recommend...

Please help, also could you show the formulas as well. Please help. Does it look better now, the first excel sheet goes all the up to 12 & then the total. please Sprinkles Ice Cream Shoppe Please...

Write a Java program that will read a json files ( MidsummerNightsDream.json) parse them with the gson library and the set of Java methods you were provided, and create a set of HTML web pages. home...

I need helping figuring out how the financial statements would be adjusted after something like this occurs. Would someone be able to explain how I would figure that out please? Here is what I have...

AFM 362 - Taxation I Fall 2020 Group Assignment Your friend Nathan was so appreciative of the advice you provided to him about incorporation of his income, so he referred a co-worker to you who...

a) Let's say a year of college currently costs $20,000 in today's dollars. If your clients' child is currently 9 years old and will start college at 18 years of age, how much will the first year of...

Please help with line 16. I've checked the 2022 tax table for a married filing jointly couple for $38,442 and it says it should be $4,200, but as you can see its incorrect. I'm not sure if I'm...

home / study / engineering / computer science / questions and answers / with r programming i need help figuring out formulas ... Question With R Programming I need help figuring out formulas to the...

Hi there, I just need help understanding how to solve for the circled part in red for cash and cash equivalents going from June 30, 2019, of $1,559.00 to June 30, 2020, cash and cash equivalents of...

Assume now that the volatility of stock is 15 percent annually. The volatility of changes in yields is 1 percent annually. Assuming zero correlation between stocks and bonds and normal distributions,...

The concentration of particulate matter (in parts per million) during a 24-hour period is given approximately by C(t) = t 24 - t 0 t 24

Sarah Phillips has just sold her consulting business to a key employee, who has obtained financing for a portion of the purchase of the business. If Sarah agrees to receive a portion of the business...

What is an example of constructive feedback? provide reference