Combining IF formulas

[nav505]

Hi, with this post I have attached a spreadsheet, in it I am trying to calculate the profit based on check boxes, if the flat rate delivery charge is checked, then this should be included in calculating the profit instead of the original delivery charge, and if the discount check box is checked, then the sales should be subtracted by the discount. I have so far created an IF formula for profit that includes whether the flat rate delivery charge is included or not, based on whether its check box is checked, but how can I incorporate the discount fee into the formula.

Combining IF Functions.xlsx

[benishiryo]

hi nav505. just subtract or add another IF:
=IF(FLAT_RATE_DELIVERY=FALSE,(SUM(Income)-SUM(expenses)),(SUM(Income)-SUM(E9,E11:E12,K4)))-IF(DISCOUNT=FALSE,0,K7)

you can also exclude the FALSE if it's not too confusing. the default of the logical test is a TRUE, so by not typing =FALSE or =TRUE, it's saying the latter. you also don't need some brackets. so:
=IF(FLAT_RATE_DELIVERY,SUM(Income)-SUM(E9,E11:E12,K4),SUM(Income)-SUM(expenses))-IF(DISCOUNT,K7,0)

[dredwolf]

This is the way I would do it :Combining IF Functions.sol1.xlsx

Was not sure how the original Income/Expenses were being generated, so i used the cells beside them to show the formula's (high-lighted in orange/dark yellow)

This makes only the values affected change and keeps the Profit calculation simple

Hope this helps

[nav505]

ok, thank you for the help, much appreciated