Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I do not know what forumla to use here. 23 In cells B15:D15, use a logical function to recommend which company B-Trendz should use to

image text in transcribed
image text in transcribed
I do not know what forumla to use here.
23 In cells B15:D15, use a logical function to recommend which company B-Trendz should use to create and maintain the online website. The function should return the company name from row 2 if the website will be maintained for at least two years and the monthly payment is $2,100 or less. If the value is false, the cell should remain blank fx E O O A g @ Define Name - Insert Function AutoSum Recently Financial Logical Text Date & Lookup & Math & More - Used - - Time - Reference - Trig. Functions Function Library Define Name - use in Formula Create from Selection Defined Names Manager B15 - x for 1 Company Options Online Solutions Designs website for online product sales Online For You Designs website for online product sales Creative Development Designs website for online product sales 3 Service/Product 4 Maintains website 5 Cost 100,000.00 $ 110,000.00 $ 120,000.00 8 Loan Options 9 Term in Years 10 Interest 11 Monthly Payment 12 Total Loan Payment $ 13 Total Interest 5.05% $1,010.00 105,050.00 $ 5,050.00 $ 5.05% $1,111.00 115,555.00 $ 5,555.00 $ 5.05% $1,212.00 126,060.00 6,060.00 15 Best Option SalesComparison Retail Predictions Online

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

Value Investing

Authors: Mike Hartley

1st Edition

979-8864443309

More Books

Students also viewed these Finance questions