Excel Formule

Roel · #1 11-30-2011, 02:15 AM

Heyz,

Im not very good with formules, thats why im asking my question here.

I want a formule that says:

IF A3 is empty then put result A1 in A3, if A1 is empty, then put result A2 in A3. If both A1 + A2 is empty, then show ! in A3.

Can any1 make me a proper and working formule of this?

Thanks in advance!

Colin Legg · #2 11-30-2011, 02:37 AM

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