MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula with IF conditions


Posted by Rick Baldo on January 23, 2002 7:33 PM

Problem is I need to create a forumla in "one" cell, A2, that is dependent on a value entered in cell A1. Example: If data entered in A1 = A, then sum the values in B1 and C1, however if the data in A1 = B, then sum the values in D1 and E1, unless the data in A1 = C, then sum the values in F1 and G1, otherwise put an "X" in cell A2. Is there a limit on the number of variables that can be entered in cell A1? In Lotus (DOS)the formula is: if(A1=A,(B1+C1),@if(A1=B,(C1+D1),@if(A1=C,(D1+E1),"X"))). Your help is very much anticipated and appreciated. Thank You


Posted by on January 23, 2002 7:52 PM

=IF(A1="A",SUM(B1,C1),IF(A1="B",SUM(C1,D1),IF(A1="C",SUM(D1,E1),"X"))) Limit in excel is still 7 nested IFs?(NT)