DSR Forum

DSR "Dutch Synthetic Reefing" => DSR Calculator & Manual => Topic started by: griff500 on March 17, 2018, 11:20:44 pm

Title: Problem with #VALUE! in Iron correction field
Post by: griff500 on March 17, 2018, 11:20:44 pm
I've tried Microsoft Excel and Open Office, both on Mac, and I get errors and no value generated. Macros enabled in both.

I'm using the latest version linked to from this forum.

Any ideas?
Title: Re: Problem with #VALUE! in Iron correction field
Post by: griff500 on March 19, 2018, 12:16:25 pm
?
Title: Re: Problem with #VALUE! in Iron correction field
Post by: griff500 on March 19, 2018, 12:20:18 pm
Ok, I figured it out.

In the target value for iron you have 0,15 instead of 0.15... the formula cannot create a value because the format is not numerical in the default value due to using a ',' instead of a '.'.