Close
Products
Back
View All Products
For Project Management
Back
Gantt
JavaScript Gantt Chart
Scheduler
JavaScript Scheduler
Kanban
JavaScript Kanban Board
To Do List
new
JavaScript To Do List
Event Calendar
new
JavaScript Event Calendar
For Data Analysis
Back
Diagram
JavaScript Diagram
Spreadsheet
JavaScript Spreadsheet
Pivot
JavaScript Pivot Table
For Content Management
Back
Vault
File Uploader
Rich Text Editor
JavaScript Rich Text Editor
Chatbot
JS widget for AI support agents
UI Widgets Library
Back
Suite
JavaScript UI Library with
20+ Full-Featured UI Widgets
Back
Suite
Grid
TreeGrid
Tree
Calendar
Charts
Save with DHTMLX Bundles
View All Products
Services
Pricing
Learning & Support
Back
Learning & Support
Explore
Back
Documentation
API references and guides
Samples
UI examples of DHTMLX components
Demos
App examples built with DHTMLX
Integrations
Guides on popular technologies
Use
Back
Developer Helping Tools
Export modules & other additions
Code Snippets
Code examples of DHTMLX widgets
Read
Back
Blog
Release articles, announcements, dev tips
Customer List
Who our clients are
Customer Stories
Interviews with DHTMLX clients
Testimonials
Feedback from our clients
Connect
Back
Technical Support
Official tech & license-related support
Community Forum
Technical help from the community
Contact Us
Download
DHTMLX
spreadsheet的函数查找不到对应的值显示#ERROR
Spreadsheet
Sissi_W
June 3, 2024, 7:00am
#1
image
1792×463 84.1 KB
spreadsheet的函数,查找不到对应的值的时候,返回值是什么?是#ERROR还是#N/A?那有没有什么函数可以判断这个查找不到的返回值为#ERROR或者是#N/A,或者直接实现查找不到的时候,返回FALSE。或者增加Excel的ISNA()函数,不然都没办法去判断这个查找不到任何结果的时候的返回值,导致单元格显示的全是#ERROR
Get a
guaranteed answer
from DHTMLX technical support team under the most suitable
support plan