Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Please help me to create this formula:
A1 + A2 = B2 IF A1 + A2 = 2 THEN B2 = 2 IF A1 + A2 = 3 THEN B2 = 3 and so on IF A1 + A2 = 10 THEN B2 = 1 IF A1 + A2 = 11 THEN B2 = 2 IF A1 + A2 = 12 THEN B2 = 3 IF A1 + A2 = 13 THEN B2 = 4 IF A1 + A2 = 14 THEN B2 = 5 IF A1 + A2 = 15 THEN B2 = 6 IF A1 + A2 = 16 THEN B2 = 7 IF A1 + A2 = 17 THEN B2 = 8 IF A1 + A2 = 18 THEN B2 = 9 IF A1 + A2 = 19 THEN B2 = 1 A1 and A2 must have a value between 1 and 9 otherwise ERROR! -- Thomas |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel 2002 - copying formulas across worksheets | Excel Discussion (Misc queries) | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
How do I get to master Excel functions and formulas? | Excel Worksheet Functions |