Hello. I am having trouble with my homework. I will first put in the question in addition to the formulas I have attempted. I believe I almost have the formula, but something just isn't quite right.
I am using defined names, which are as follows:
<tbody>
</tbody>
#6: In cell C19, enter a formula to calculate the revenue at the break-even point, which
is determined by the break-even point multiplied by the sales price per unit. Use the
IFERROR function to display a blank cell instead of an error value.
My formula attempts:
#1 =IFERROR(C18*CostPerUnit,"") C18(BREAK EVEN POINT(Units Sold): =IFERROR(MonthlyExpenses/(PricePerUnit-CostPerUnit),"")
#2 =IFERROR([MonthlyExpenses/(PricePerUnit-CostPerUnit)*CostPerUnit,"")
Hopefully this is enough to help me on. I am not looking for the answer but rather guidance --- an answer will not help me learn/understand as well as maybe explanation or tip or show me where i'm right or wrong in my formula building. Thank you!
I am using defined names, which are as follows:
CostPerUnit | ='Profit Analysis'!$C$16 | |
MonthlyExpenses | ='Profit Analysis'!$C$17 | |
PricePerUnit | ='Profit Analysis'!$C$15 |
<tbody>
</tbody>
#6: In cell C19, enter a formula to calculate the revenue at the break-even point, which
is determined by the break-even point multiplied by the sales price per unit. Use the
IFERROR function to display a blank cell instead of an error value.
My formula attempts:
#1 =IFERROR(C18*CostPerUnit,"") C18(BREAK EVEN POINT(Units Sold): =IFERROR(MonthlyExpenses/(PricePerUnit-CostPerUnit),"")
#2 =IFERROR([MonthlyExpenses/(PricePerUnit-CostPerUnit)*CostPerUnit,"")
Hopefully this is enough to help me on. I am not looking for the answer but rather guidance --- an answer will not help me learn/understand as well as maybe explanation or tip or show me where i'm right or wrong in my formula building. Thank you!