ParamQuery grid support forum

General Category => Bug Report => Topic started by: jaapmurre on May 26, 2020, 12:04:49 am

Title: Bug in Excel-like formulas with IF function and <>
Post by: jaapmurre on May 26, 2020, 12:04:49 am

This formula gives error 'Unexpected token >' but should not: =IF(B5<>"",IF(B6<>"",0,1),.5)

But this works: =IF(B5<>"",IF(TRUE,0,1),.5) and produces 0

Perhaps the parser chokes on repeated <>. E.g., this also produces Unexpected token >:

=AND(B5<>"",B6<>"")

Title: Re: Bug in Excel-like formulas with IF function and <>
Post by: paramvir on June 08, 2020, 08:45:05 am

This has been fixed in v7.3.0