Trouble with formula

Questions and answers on how to use XLSReadWriteII 3/4/5.
Post Reply
Mig_2000
Posts: 4
Joined: Thu Jan 29, 2009 10:11 pm

Trouble with formula

Post by Mig_2000 »

I received an error message with this formula IF((Q10=0),0,(Q10*E10)-L10)

The error is Unknown Name Q10


If i use IF(sum(Q10=0),0,(Q10*E10)-L10) or IF((0+Q10=0),0,(Q10*E10)-L10) i don't received this error.

P.S The formula work fine in version 2.

I have a version 4.00.17

Thanks
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Trouble with formula

Post by larsa »

Hello

This will be fixed in the next update.
Lars Arvidsson, Axolot Data
Post Reply