| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Want a blank not zero
I would like the cell to be blank, instead of zero, if nothing is in the cell. This is the formula I entered. I did one before and I got a blank so I must be doing something wrong.  =IF(LEN(VLOOKUP(A2,'FD RUN LIST MASTER2'!$A$12:$AM$606,'FD RUN LIST MASTER2'!$C$12))=0," ",(VLOOKUP(A2,'FD RUN LIST MASTER2'!$A$12:$AM$606,'FD RUN LIST MASTER2'!$C$12,FALSE))) -- CBrausa ------------------------------------------------------------------------ CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677 View this thread: http://www.excelforum.com/showthread...hreadid=519930 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Want a blank not zero
TRy
=IF(ISNA(VLOOKUP(A2,'FD RUN LIST MASTER2'!$A$12:$AM$606,'FD RUN LIST MASTER2'!$C$12))," ", (VLOOKUP(A2,'FD RUN LIST MASTER2'!$A$12:$AM$606,'FD RUN LIST MASTER2'!$C$12,FALSE))) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "CBrausa" wrote in message ... I would like the cell to be blank, instead of zero, if nothing is in the cell. This is the formula I entered. I did one before and I got a blank so I must be doing something wrong. =IF(LEN(VLOOKUP(A2,'FD RUN LIST MASTER2'!$A$12:$AM$606,'FD RUN LIST MASTER2'!$C$12))=0," ",(VLOOKUP(A2,'FD RUN LIST MASTER2'!$A$12:$AM$606,'FD RUN LIST MASTER2'!$C$12,FALSE))) -- CBrausa ------------------------------------------------------------------------ CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677 View this thread: http://www.excelforum.com/showthread...hreadid=519930 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions | |||
| enter numbers in blank cells | Excel Worksheet Functions | |||
| Counting blank and filled cells within a range. | Excel Discussion (Misc queries) | |||
| blank cells | Excel Discussion (Misc queries) | |||
| VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions | |||
Linear Mode
