i been working with excel and been fond of using the IF function, but even
today, i had not found any excel worksheet function that cannot be
governed/read by the 7 IFs function. Yet I still need to learn and ask our
professional excel users in this forum if the 7 IFs cannot accomodate other
functions.

Excel has a long list of functions for a lot of working categories. Yet the
IF function is not explained clearly about its limitation - limit of
inserting other function - within its formula.

=IF(logical_test,value_if_true,value_if_false).

pls. share your experience to avoid errors for users like me?