| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
0 value in null value cell
How do I stop a 0 from showing up in a cell running a lookup function when
there is a null value? Thanks, Todd |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
0 value in null value cell
Hi,
you can use and If statement so can eliminate the 0 or null Try and let me know =IF(LOOKUP(C3,F3:I4)=0," ",LOOKUP(C3,F3:I4)) -- Sigmund "FP Novice" wrote: How do I stop a 0 from showing up in a cell running a lookup function when there is a null value? Thanks, Todd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If cell not null use that value | Excel Worksheet Functions | |||
| Failed to save table attributes of (null) into (null). | Excel Discussion (Misc queries) | |||
| Sum a NULL cell | Excel Worksheet Functions | |||
| If A cell Is null Do Nothing. | Excel Programming | |||
| cell value based on null/not null in another cell | Excel Worksheet Functions | |||
Linear Mode
