Nested IF keeps showing me "#NAME?" error [in file created by ClosedXML]

Hi, I'm using the ClosedXML library for Vb .NET to create an excel file with multiple sheets and formulas.
In each of these sheets I use this formula: =IF(C21="YES",IF(C24="NO",+C34*B41,0),0)
While it works fine in almost all the sheets, sometimes it shows me a "#NAME?" error, but if I press "Enter" on it the error disappears and it shows me the correct value. I controlled when I pressed "Enter" if Excel edited my formula, but it's the same as before. Does anyone know if it's just a ClosedXML bug or are there any issues in my IF?
Thanks in regards,
Riccardo

PS: in this case, C21 and C24 are "YES", while C34 = "0,00$" and B41 = "0,00%"

Check out, =if(and(

https://support.microsoft.com/en-gb/...2-5c193a236d97

ClosedXML is an open-source library for creating Excel files without using Excel. It is primarily intended for web applications that need to generate Excel files for user download.

The formula you say you are using has the English function IF but your screenshot shows the Italian function SE. What does the code look like that calls ClosedXML?

I don't know what level of support is provided, if any at all. From your description I would guess that the problem is that it is creating an Excel file using English names for the functions and you are opening it in a regionalization that uses Italian names. The specification for ClosedXML does not indicate whether it has been designed and tested for regionalizations other than U.S.

My guess is it's a bug in ClosedXML, but I don't know if it's a known bug. This is one drawback of using free open-source code. Is there a community forum specific to ClosedXML where you can ask this question?

BTW

Formula:

Please Login or Register  to view this content.

the "+" is unnecessary