Thread: [Solved] Excel Formule
View Single Post
 
Old 11-30-2011, 02:37 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default
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,"!"))
Reply With Quote