Re: if testing

[Jean Bréfort <jean brefort normalesup org>]

Le lundi 24 décembre 2007 à 03:43 +0100, Mauro Santini a écrit :
> Dear gnumeric developer,
> 
> I was using gnumeric with linux first and now also with vista cuz it 
> works great and has the same format with both OS.
> 
> by the way, I,m trying to implement a simple if statement between cells 
> and i receive an 'incorrect warning message'
> 
> the statement sounds: if(e130<0,((e395-e3)*e130),0).
> unfortunally your if tutorial is not really exhaustive but i supposed my 
> statement to be ok. could u please let me know what is wrong?

What is the decimal separator in your locale? if it is ',', you must use
';' as the argument separator, so your formul would look like:
=if(e130<0;((e395-e3)*e130);0)

> the fields are all numeric; e395 and e3 are setted as euro values whilst 
> e130 number without any setting
> 
> thanks for your support
> 
> wish u a merry christmass and happy new year
> 
> mauro
> 
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> http://mail.gnome.org/mailman/listinfo/gnumeric-list
>