Answered step by step
Verified Expert Solution
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
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 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 JStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started