[fr-users] Calc - formule

DEPREZ Christophe PREF35 SSIT <[email protected]>
Newsgroups gmane.comp.openoffice.general.french
Message-ID <[email protected]>
Bonjour à tous,

Je cherche à afficher en A2 la valeur "matin" si A1 est inférieur à 
12:00:00 sinon "après-midi"

La formule suivante SI(A1<12:00:00;"matin";"après-midi") renvoie Err :509

Merci pour votre aide

Christophe
--
------------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected] with Subject: help
christophe_deprez.vcf (text/x-vcard, 461 B)
begin:vcard
fn:<b>Christophe DEPREZ</b>  
n:DEPREZ;Christophe
org;quoted-printable;quoted-printable:T=C3=A9l : 02.99.02.12.82 - <b><font color=3D green><i>Pensons Environnem=
	ent, soyons =C3=A9co-responsable, n'imprimons que si n=C3=A9cessaire !</i=
	></b>;Service Informatique Interminist=C3=A9riel de l'Etat
email;internet:[email protected]
title:Service de la Logistique de l'Etat
tel;work:02.99.02.12.82
version:2.1
end:vcard
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.