Question

In cell B25, calculate fixed costs by use a nested IF function to display the Low Risk Administrative Cost if the value in cell B18 is Low, to display the High Risk Administrative Cost if the value in cell B18 is High or display the Standard Risk Administrative Cost. Format as Accounting with 0 decimal places.

Bean Healthcare Beantacob - Excel Pile fx Home Insert Page Layout Formulas Data Review View Help 2 A @ @ Auto Sum Recently Financial logical Test Date & lookup & Math & More - Used - - - Time Reference Trig functions Tell me what you want to do Define Name - Trace Precedents Di Show Formulas grace Dependents Error Checking - Cuse in forma Insert Function Name Manager W Wind Create from Selection Remove Arrows - Evaluate Formula Defined Names 3.25 H G Probability Tables S 3.00 Profit and Loss 8 Marginal Policy Cost Per Customer 9 Fixed Costs 10 Low Risk Administrative Cost 11 Standard Risk Administrative Cost 12 High Risk Administrative Cost 13 Processing Fee 14 Policy Capacity 15 Claim Assessment Individual Prob 25% $ 10,000.00 $ 25,000.00 $ 50,000.00 86.00 5,000 6.00 Cumulative Prob Claim Value or Risk 0.00 Low 0.25 Standard 0.85 High 60% 15% Low Risk Demand Individual Prob 20% High 700 10N 17 18 Claim Value or Risk 19 Demand 20 Risk level 21 Total Policies Underwritten 22 Cancellation Vouchers issued Cumulative Prob 0.00 0.20 0.55 0.80 0.95 4.300 1,300 2.400 5.000 25% Individual Individual Prob Cumulative Prob Demand 0.00 900 0.10 1.100 0.35 1.300 0.70 1.500 10% 0.00 1,700 900 1.100 1,300 1.500 15% 355 20% 300.00 24 Pald Revenue 25 Feed Cost 26 Marginal Cost 27 Voucher Cost Individual Prob 5% 20% Standard Risk Cumulative Prob 0.00 0.05 0.25 0.45 0.80 Family Individual Prob Cumulative Prob Demand 20% 0.00 1.650 35% 0.20 2,150 0.55 2.650 ONO 3150 0.95 3650 20% Demand 1.100 1,500 1.900 2.300 2,700 Total Revenue Total Cost 15 Profit 35% 20% Individual Prob High Risk Cumulative Prob 0.00 556 20% 0.05 Demand 1.900 2.700 3.500 4,300 20% 0.25 35% 0.45

Answer 1

IF(B18="Low",B10, I F (B18="High",B12,B11)) B25 A C. E F G 7 $ 10,000.00 Standard Risk Administrative Cost $ 25,000.00 $ 50,000.00 Low Risk Administrative Cost 10 11 High Risk Administrative Cost 12 13 14 15 16 17 High 18 Claim Value or Risk 19 20 21 22 23 24 25 Fixed Cost $ 50,000 26 27 28

for formula view, refer to the image below -

IF(B18="Low",B10, IF (B18="High",B12,B11)) B25 B A. D E F G 7 8 Low Risk Administrative Cost 10000 10 Standard Risk Administrative Cost 125000 11 50000 High Risk Administrative Cost 12 13 14 15 16 17 18 Claim Value or Risk High 19 20 21 22 23 24 |IF(B18="Low",B10,1F(B18="High", B12,B11)) 25 Fixed Cost 26 27 28. X co a

In case you have any query, kindly ask in comments.