Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How are empty cells referenced in Excel in IF statements?
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="",...). |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How are empty cells referenced in Excel in IF statements?
=IF(ISBLANK(A3), "A3 is Empty", "A3 is NOT empty") -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=551166 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How are empty cells referenced in Excel in IF statements?
Hi!
Try something like this: =IF(LEN(A3)0,............................ Biff "MOnewt" wrote in message ... 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="",...). |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How are empty cells referenced in Excel in IF statements?
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="",...). |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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="",...). |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How are empty cells referenced in Excel in IF statements?
=IF(ISBLANK(A1), "do this", "else do that")
But beware of functions that display nothing! An experiment: In A1 enter value 10 In B 1 enter formula =IF(A15," ","X") - a space is displayed In C1 enter formula =IF(ISBLANK(B1),"blank","not blank") In D1 enter formula =IF(B1=" ","blank","not blank") Then try with =IF(A15,"","X") - a null is displayed -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MOnewt" wrote in message ... 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="",...). |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How are empty cells referenced in Excel in IF statements?
Do not really make out what your problem is. If you want to do something
only if a specific cell is not empty, you should use <"", and not ="". +IF(A3<"",A3*C3,"") means IF A3 is not equal to nothing - iow contains a value - THEN multiply A3 with C3, ELSE leave blank. Be careful though. A space is <"". Text is <"", and a number is < "". If you want A3 to contain a numeric value as critria, but it contains a 0 or alfa character, you will get an #N/A result. "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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel | |||
How to make empty cells as zero in excel add-ins for SQL Server an | Excel Worksheet Functions |