April 18, 2024, 05:55:07 pm

News:

Unlogical names will be denied acces. Check your mail/spambox!


Problem with #VALUE! in Iron correction field

Started by griff500, March 17, 2018, 11:20:44 pm

Previous topic - Next topic

griff500

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?


griff500

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 '.'.