Lazarus
Home
Help
TinyPortal
Search
Login
Register
Lazarus
»
Forum
»
Programming
»
Packages and Libraries
»
FPSpreadsheet
»
Bug in the formula MATCH, INDEX, IF
Free Pascal
Website
Downloads
Wiki
Documentation
Bugtracker
Mailing List
Lazarus
Website
Downloads (Laz+FPC)
Packages (OPM)
FAQ
Wiki
Documentation (RTL/FCL/LCL)
Bugtracker
CCR Bugs
GIT
Mailing List
Other languages
Foundation
Website
Useful Wiki Links
Project Roadmap
Getting the Source
Screenshots
How to use the forum
About donations (wiki)
Bookstore
Computer Math and Games in Pascal
(preview)
Lazarus Handbook
Search
Advanced search
Recent
Treeview: full-width back...
by
wp
[
Today
at 01:03:20 am]
FPC can't link screen_dem...
by
mccfrank
[
Today
at 12:06:32 am]
ThemeServices.DrawText in...
by
regs
[February 08, 2025, 11:25:01 pm]
my programs crash
by
turunk
[February 08, 2025, 10:56:26 pm]
Gradient with fcl-image
by
wp
[February 08, 2025, 10:46:18 pm]
using RunCommand to wrap ...
by
nomorelogic
[February 08, 2025, 10:39:37 pm]
ellipse ? off topic
by
BubikolRamios
[February 08, 2025, 10:15:18 pm]
Failed to connect to a si...
by
silvercoder70
[February 08, 2025, 09:54:18 pm]
FLIF and FUIF Formats (Fr...
by
Tomxe
[February 08, 2025, 09:43:37 pm]
Reading FLIF images in La...
by
Tomxe
[February 08, 2025, 09:43:03 pm]
Basic canvas drawing
by
Jonny
[February 08, 2025, 09:31:17 pm]
Scrollbox, scrollbar Back...
by
bbrx
[February 08, 2025, 08:50:08 pm]
Transparent animation
by
majolika
[February 08, 2025, 08:17:52 pm]
API definitions
by
440bx
[February 08, 2025, 07:35:57 pm]
Candlestick chart
by
ronhud
[February 08, 2025, 07:31:12 pm]
missed warning
by
Paolo
[February 08, 2025, 07:30:04 pm]
Error assembling some lab...
by
Fred vS
[February 08, 2025, 07:10:13 pm]
Building the FPC cross-co...
by
marcov
[February 08, 2025, 07:09:09 pm]
IsNan
by
Paolo
[February 08, 2025, 06:58:55 pm]
HelpNDoc.com and Pascal
by
paule32
[February 08, 2025, 06:42:02 pm]
RTL: little changes
by
PascalDragon
[February 08, 2025, 06:22:35 pm]
Drawing with psInsidefram...
by
Jonny
[February 08, 2025, 06:04:27 pm]
SnapTRAINER
by
jclavier
[February 08, 2025, 05:40:25 pm]
[SOLVED] How to add new ...
by
jmpessoa
[February 08, 2025, 05:31:53 pm]
jSaveDialog
by
biologic
[February 08, 2025, 05:01:09 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: Bug in the formula MATCH, INDEX, IF (Read 671 times)
veb86
Jr. Member
Posts: 82
Bug in the formula MATCH, INDEX, IF
«
on:
January 18, 2025, 02:40:23 pm »
Error in return values:
MATCH - should return #N/A
INDEX - when receiving one of the #N/A values, should also return #N/A
IF - when receiving one of the #N/A values, should also return #N/A
Please see the attached picture and example.
Logged
veb86
Jr. Member
Posts: 82
Re: Bug in the formula MATCH, INDEX, IF
«
Reply #1 on:
January 29, 2025, 01:05:41 pm »
Hi.
I see that you have made many commits on this bug. Can I upgrade and start using the library?
Logged
wp
Hero Member
Posts: 12589
Re: Bug in the formula MATCH, INDEX, IF
«
Reply #2 on:
January 29, 2025, 08:21:59 pm »
Just writing some more unit tests, but I don't think that much will change here.
Logged
veb86
Jr. Member
Posts: 82
Re: Bug in the formula MATCH, INDEX, IF
«
Reply #3 on:
January 30, 2025, 06:48:25 am »
I will try. Thank you very much.
Logged
Print
Pages: [
1
]
« previous
next »
Lazarus
»
Forum
»
Programming
»
Packages and Libraries
»
FPSpreadsheet
»
Bug in the formula MATCH, INDEX, IF
TinyPortal
© 2005-2018