Explanation
The goal is to demonstrate how other formulas and functions can benestedinside theIF function.
The example is a simple quantity-based discount formula.
The example below shows how this works.
Otherwise, we want to calculate the total normally.
Otherwise, it just calculates the total price without any discount.
you could then copy the formula down column E to apply it to all items in the spreadsheet.
Other calculations
The calculations used inside the IF function can be customized as needed.
you’re able to findmany examples in this list.
More than one condition can be tested by nesting IF functions.
AND returns TRUEonly if all the conditions are met.
If any conditions are not met, the AND function returns FALSE.
