Excel Formule

		Microsoft Office Forums > Microsoft Excel > Excel
Excel Formule

11-30-2011, 02:37 AM

Colin Legg Colin Legg is offline

Windows 7 32bit Excel Formule

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

The wording here is circular:

Quote:

IF A3 is empty then put result A1 in A3

However, I hope, in fact, that you want to put a formula in A3 and that formula would be this:

=IF(A1<>"",A1,IF(A2<>"",A2,"!"))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA code from Excel 2007 in Excel 2010	csam63	Excel Programming	1	10-07-2011 10:46 AM
Excel Hyperlinks crash Excel programme	martinlest	Excel	8	01-26-2011 04:23 AM
Opening multiple Excel files within the same Excel window.	lost9471	Excel	2	05-01-2010 01:57 PM
How do I use an Excel form to populate and Excel spreadsheet	apostht	Excel	0	05-21-2006 11:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:25 PM.