close
How many IF OR statements can one have in one formula?
I need 12 and if I can only have a MAx of 7, do I just split over 2 cells?
2 options.
Split over 2 cells
Or
Make a formula with 6 of the If's and define it with a name. Then make a
formula with the other 6 If statementsx and define it with a name. Then in
the cell where you want the answer make a formula with both of your named
formulas in it.
Hope this helps.
Bill Horton
quot;Johnquot; wrote:
gt; How many IF OR statements can one have in one formula?
gt;
gt; I need 12 and if I can only have a MAx of 7, do I just split over 2 cells?
gt;
gt;
gt;
gt;
全站熱搜
留言列表
