Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone help me write an IF statement for this problem that includes a spin button? Part 1: placement of If statement goes to E4

image text in transcribedCan someone help me write an IF statement for this problem that includes a spin button?

Part 1: placement of If statement goes to E4 cell. =IF (this cell C7 =0, then set this to E3, if not, set it to E3*quantity, 1+B2)

Part 2: Placement of IF statement goes in E5(73,600) =IF(C7=0, E5*E3, if c7=1, then set to E3*B7,1-B7)

Part 3:: = Placement of IF statement goes in E6(110,400) = IF( C7=0, take E4 * quantity, 1-B7)

I have tried various IF statements, but they mess up my cells

Thank you for helping

Clipboard 5 V J 16 1 Font k) A 1 X Additional Sales Original sales forecast Schedule 1: Sales Forecast Credit sales Cash sales Credit Sales new policy Schedule 2: Cash Collections Cash sales this month o Credit sales last month Total collections 2 3 fox A S D Part 2 Par +3 Alignment B 5 Number 5 Styles D E F G Sales schedule 20% March April May June July 115.000 184.000 140.000 116.000 92.000 92.000 115.000 184.000 140.000 46.000 73.600 56.000 116.000 40% 46.400 36.800 55.200 60% 69.000 110.400 84.000 69.600 70% 1.000 55.200 69.000 110.400 84.000 69.600 56.000 36.800 46.000 73.600 105.800 156.400 157.600 125.600 Cells H August I Apr-July 92.000 555.000 Editing J

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

Finance Led Capitalism Shadow Banking Re Regulation And The Future Of Global Markets

Authors: Robert Guttmann

1st Edition

1137398566, 978-1137398567

More Books

Students also viewed these Finance questions