Question: 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 thatCan 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

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 Finance Questions!