![]() ![]() To calculate the trade discount percentage for clients based on the table below TOTAL PURCHASES However if more elaborate testing of data will be carried out then the Nested If Statement can be used. ![]() The If statement can be used to conduct conditional tests on values and formulas. As a result more elaborate tests of data can be constructed. The Nested IF statement enables one to calculate multiple conditions in a formula. ![]() Do you need to calculate multiple conditions in a formula? Similar to the example below where a specific trade discount percentage has been used depending on the quantity purchased? If that is the case then you can use the Nested IF statement.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |