| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show's #N/A please to showblank.
Hello from Steved
How can I make the below formula please to show blank cells in stead off #N/A =SUBSTITUTE(TEXT(VLOOKUP("City",'2nd Week'!$A$1:$H$10000,2,0),"#.00"),".",":")*1 Thankyou. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Show's #N/A please to showblank.
=IF(ISNA(VLOOKUP("City",'2nd
Week'!$A$1:$H$10000,2,0)),"",SUBSTITUTE(TEXT(VLOOK UP("City",'2nd Week'!$A$1:$H$10000,2,0),"#.00"),".",":")*1) -Simon "Steved" wrote: Hello from Steved How can I make the below formula please to show blank cells in stead off #N/A =SUBSTITUTE(TEXT(VLOOKUP("City",'2nd Week'!$A$1:$H$10000,2,0),"#.00"),".",":")*1 Thankyou. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Show's #N/A please to showblank.
Thank's Simon.
"SiC" wrote: =IF(ISNA(VLOOKUP("City",'2nd Week'!$A$1:$H$10000,2,0)),"",SUBSTITUTE(TEXT(VLOOK UP("City",'2nd Week'!$A$1:$H$10000,2,0),"#.00"),".",":")*1) -Simon "Steved" wrote: Hello from Steved How can I make the below formula please to show blank cells in stead off #N/A =SUBSTITUTE(TEXT(VLOOKUP("City",'2nd Week'!$A$1:$H$10000,2,0),"#.00"),".",":")*1 Thankyou. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Chart which shows average line with below and above figures | Charts and Charting in Excel | |||
| Excel shows formula, not result | Excel Discussion (Misc queries) | |||
| cell shows 20. Formula shows 20. why not 540/27 | Excel Worksheet Functions | |||
| Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
| Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Linear Mode
