Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. row 3 needs to be 20% higher than row 4. write an

Row 3 needs to be 20% higher than row 4. Write an if statement...

70.2K

Verified Solution

Question

Finance

Row 3 needs to be 20% higher than row 4.

Write an if statement where if C7 = 0, then set it equals to E3 if not then set it equals to E3 * 1 + B2.

A B C D E F G H I

ROW 1 Sales schedule
% Additional sales 20% March April May June July August Apr - July
original sales forecast 92.000 115.000 184.000 140.000 116.000 92.000 555.000
Schedule 1: Sales Forecast
92.000 115.000 184.000 140.000 116.000 92.000 555.000
Credit sales 40% 36.800 46.000 73.600 56.000 46.400
Cash sales 60% 55.200 69.000 110.400 84.000 69.600
Credit sales new policy 70% 0.000
Schedule 2: Cash Collections
Cash sales this month 55.200 69.000 110.400 84.000 69.600
Credit sales last month 36.800 46.000 73.600 56.000
Total collections 105.800 156.400 157.600 125.600

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Statistics
1.2K views

You are working with the marketing team for a FMCG firm that produces shaving cream. The...

Electrical Engineering
1.2K views

‏Solar water heating systems using air as a working medium are considered as passive systems as...

Biology
1.2K views

Compared to Bryophytes Tracheophytes have all of these choices O ability to make woody tissue...

Calculus
1.2K views

The velocity function is v t t 6t 8 for a particle moving along a...

Algebra
1.2K views

Find the inverse of f x 4x for x 0 The inverse function is f...

Algebra
1.2K views

10 4 3 13 4 7 16 4 10 11 4 2 14 7 8...

Accounting
1.2K views

1) Which of the following is an advantage of cash basis accounting vs. accrual basis...

Accounting
1.2K views

Bonkowski Corporation makes one product and has provided the following information to help prepare the...

Accounting
1.2K views

Exercise 4: Review the following completed example for a bond issued at a price of...

Finance
1.2K views

Assignment Here are simplified financial statements for Phone Corporation in a recent year INCONE STATEMENT...

Finance
1.2K views

For its most recent year a company had Sales (all on credit) of $830,000 and...

Accounting
1.2K views

SAME QUESTION, JUST DIFFERENT STEPS. PLEASE HELP!! Problem 8-05 Some of the information found...