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 > _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list