Recent

« previous next »
Pages: [1]

Author Topic: Bug in the formula MATCH, INDEX, IF  (Read 998 times)

veb86

  • Jr. Member
  • **
  • Posts: 93
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: 93
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: 12907
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: 93
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
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018