Thread
:
=IF problem
View Single Post
#
2
Posted to microsoft.public.excel.misc
Pete
Posts: n/a
=IF problem
The maximum number of nested IF statements is 7 (or 8, depending on how
they are counted). If you have more conditions then the VLOOKUP( )
function can be used in conjunction with a table of available values
and outcomes.
Pete
Reply With Quote