Scribd
Upload
14 views3 pages

Understanding the IFS Function in Excel

Uploaded by

hiihowru9876
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
14 views3 pages

Understanding the IFS Function in Excel

Uploaded by

hiihowru9876
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

IFS Function

Item name When IFS used When IFS used with ELSE
Spinach Green Vegetable Green Vegetable
Capsicum Vegetable Vegetable
Cabbage Green Vegetable Green Vegetable
Coffee Beverage Beverage
Apple Fruit Fruit
Banana Fruit Fruit
Pepper #N/A Misc

This file is for educational purposes only. E&OE

Corporate Finance Institute®


[Link]
IFS Function

Name of Total purchases Discount using nested Discount using


Customer made by them IF IFS
Emy 650 10% 10%
Liliy 2,340 30% 30%
Ron 450 5% 5%
Ria 770 20% 20%
Tony 2,000 30% 30%
Sean 100 5% 5%

This file is for educational purposes only. E&OE

Corporate Finance Institute®


[Link]
IFS Function

Marks Grade
90 A
80 B
70 C
60 D
50 E
40 F

This file is for educational purposes only. E&OE

Corporate Finance Institute®


[Link]

You might also like