Thread: How are empty cells referenced in Excel in IF statements?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson
 
Posts: n/a
Default How are empty cells referenced in Excel in IF statements?
You've got it backwards. It should be
=IF(A3="","Empty","Full")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"pdberger" wrote in message
...
Mo:

This works in Excel 2003:

=IF(A3<"","Empty","Full")

HTH

"MOnewt" wrote:

I am trying to use an IF... function to populate a field if
another field is
not empty. The "" empty, or null expression is not valid
(A3="",...).


Reply With QuoteReply With Quote