Forum Home
Press F1
Thread ID: 86538	2008-01-20 07:31:00	Excel formula	bpt2 (6653)	Press F1

Post ID	Timestamp	Content	User
632070	2008-01-20 07:31:00	I have a column of conditional results (a1:a10) one cell of which is a number and all the others show "False". I want to create a formula in another cell which only shows the value of the cell with a number. Any help?	bpt2 (6653)
632071	2008-01-20 08:38:00	How about this in column B: =IF(A1,A1," ") =IF(A2,A2," ") etc That will put any positive values into B1, B2 etc but leave the FALSE values blank. (Simply that says: IF what's in A1 is a numeric value repeat it in column B otherwise put a blank in column B. OR =IF(A1,A1,0) if you want zero in column B.	coldot (6847)
1