| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 55031 | 2005-03-01 02:43:00 | Excel IF's | Dannz (1668) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 329251 | 2005-03-01 02:43:00 | i am trying to use an IF forumla but i cant quite get it working IF B3 = 1 then A1 = 20 = 2 =15 = 3 =10 = 4 = 5 |
Dannz (1668) | ||
| 329252 | 2005-03-01 03:11:00 | the formatting didnt work it should be IF B3 = 1 then A1 = 20 IF B3 = 2 then A1 = 15 IF B3 = 3 then A1 = 10 IF B3 = 4 then A1 = 5 |
Dannz (1668) | ||
| 329253 | 2005-03-01 03:24:00 | Copy this formula to cell a1 =IF(B3=1,20,IF(B3=2,15,IF(B3=3,10,IF(B3=4,5,0)))) |
Steven (7085) | ||
| 329254 | 2005-03-01 03:44:00 | Thankyou it worked perfectly | Dannz (1668) | ||
| 1 | |||||