| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 31444 | 2003-03-22 02:26:00 | If Function in Excel | jestuart (1592) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 130027 | 2003-03-22 02:26:00 | I want to display the contents of a cell if a particular cell is empty, but if the first cell contains data then I want that data displayed. This is what I think the formula would look like in long hand. "If A1 is blank, then display B2. If A1 <>=0 then display A1." Cheers JS |
jestuart (1592) | ||
| 130028 | 2003-03-22 03:22:00 | Try this =IF(A1="",B2,IF(A1=0,B2,A1)) -if A1 is blank, then display B2, or if A1 is ), display B2 otherwise display A1 regards, andy |
andy (473) | ||
| 130029 | 2003-03-22 03:23:00 | Whoops, curse the caps key!! Try this =IF(A1="",B2,IF(A1=0,B2,A1)) -if A1 is blank, then display B2, or if A1 is 0, display B2 otherwise display A1 regards, andy |
andy (473) | ||
| 1 | |||||