So, when i made a formule for example "=IF(A1=0.7;1;0)" and the 0.7 come from
a difference of 2 other cells example B2-B1(=0.7); It doesn't work(it puts
"0"or the result is 1) but if i write it manually (so without a formule of
difference) it works.
I solve temporatly the problem with a by pass(2 others colonnes where i put
a example of diff (IF(A1=C1;1;0)and C1 is a fix cell with the same kind of
diff so 14-13.3 and then it works) but i can't understand why with number
without "," it works(ex:1 2 3 ...) and with the number with "," it doesn't
works.
Could you say something about that?
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
Clément Marcotte
Ici, on parle français.
-- On n' apprend pas à un vieux singe à faire des grimaces "" @discussions.microsoft.com> a écrit dans le message de news:
So, when i made a formule for example "=IF(A1=0.7;1;0)" and the 0.7 come from
a difference of 2 other cells example B2-B1(=0.7); It doesn't work(it puts
"0"or the result is 1) but if i write it manually (so without a formule of
difference) it works. I solve temporatly the problem with a by pass(2 others colonnes where i put
a example of diff (IF(A1Á;1;0)and C1 is a fix cell with the same kind of
diff so 14-13.3 and then it works) but i can't understand why with number
without "," it works(ex:1 2 3 ...) and with the number with "," it doesn't
works. Could you say something about that?
Ici, on parle français.
--
On n' apprend pas à un vieux singe à faire des grimaces
"christophemiroir@yahoo.fr"
<christophemiroir@yahoo.fr@discussions.microsoft.com> a écrit dans le
message de news:8AE1AC7D-910F-4251-BD0A-B46985990267@microsoft.com...
So, when i made a formule for example "=IF(A1=0.7;1;0)" and the 0.7
come from
a difference of 2 other cells example B2-B1(=0.7); It doesn't
work(it puts
"0"or the result is 1) but if i write it manually (so without a
formule of
difference) it works.
I solve temporatly the problem with a by pass(2 others colonnes
where i put
a example of diff (IF(A1Á;1;0)and C1 is a fix cell with the same
kind of
diff so 14-13.3 and then it works) but i can't understand why with
number
without "," it works(ex:1 2 3 ...) and with the number with "," it
doesn't
-- On n' apprend pas à un vieux singe à faire des grimaces "" @discussions.microsoft.com> a écrit dans le message de news:
So, when i made a formule for example "=IF(A1=0.7;1;0)" and the 0.7 come from
a difference of 2 other cells example B2-B1(=0.7); It doesn't work(it puts
"0"or the result is 1) but if i write it manually (so without a formule of
difference) it works. I solve temporatly the problem with a by pass(2 others colonnes where i put
a example of diff (IF(A1Á;1;0)and C1 is a fix cell with the same kind of
diff so 14-13.3 and then it works) but i can't understand why with number
without "," it works(ex:1 2 3 ...) and with the number with "," it doesn't
works. Could you say something about that?
papou
Bonjour Pierre Moi ça me rappelle un fameux dialogue : - "tea for two and two for tea...." - "You are ?" - "Are you ?"
:-)))
Cordialement Pascal
"Pierre Fauconnier" a écrit dans le message de news:
Hello..
1. Say "Hello" 2. Say "Thanks for the help" 3. Speak french because tis newsgroup is Microsoft.public.FR.excel
I think your problem is that B2-B1 <> 0.7. It could be 0.7000000000001 and this answer <> 0.7 You can have a solution with round(B2-B1;1) in your formula.
Ok?
-- Pierre Fauconnier () "Le bonheur n'est pas au bout du chemin. Le bonheur EST le chemin ( proverbe zen ) Remplacez nospam.nospam par pfi.be pour répondre. Merci
"" @discussions.microsoft.com> a écrit dans le message de news:
So, when i made a formule for example "=IF(A1=0.7;1;0)" and the 0.7 come from a difference of 2 other cells example B2-B1(=0.7); It doesn't work(it puts "0"or the result is 1) but if i write it manually (so without a formule of difference) it works. I solve temporatly the problem with a by pass(2 others colonnes where i put a example of diff (IF(A1Á;1;0)and C1 is a fix cell with the same kind of diff so 14-13.3 and then it works) but i can't understand why with number without "," it works(ex:1 2 3 ...) and with the number with "," it doesn't works. Could you say something about that?
Bonjour Pierre
Moi ça me rappelle un fameux dialogue :
- "tea for two and two for tea...."
- "You are ?"
- "Are you ?"
:-)))
Cordialement
Pascal
"Pierre Fauconnier" <pierre.fauconnier@nospam.nospam> a écrit dans le
message de news: OGKvW2sWFHA.2540@tk2msftngp13.phx.gbl...
Hello..
1. Say "Hello"
2. Say "Thanks for the help"
3. Speak french because tis newsgroup is Microsoft.public.FR.excel
I think your problem is that B2-B1 <> 0.7. It could be 0.7000000000001 and
this answer <> 0.7
You can have a solution with round(B2-B1;1) in your formula.
Ok?
--
Pierre Fauconnier (pierre.fauconnier@nospam.nospam)
"Le bonheur n'est pas au bout du chemin. Le bonheur EST le chemin (
proverbe zen )
Remplacez nospam.nospam par pfi.be pour répondre. Merci
"christophemiroir@yahoo.fr"
<christophemiroir@yahoo.fr@discussions.microsoft.com> a écrit dans le
message de news: 8AE1AC7D-910F-4251-BD0A-B46985990267@microsoft.com...
So, when i made a formule for example "=IF(A1=0.7;1;0)" and the 0.7 come
from
a difference of 2 other cells example B2-B1(=0.7); It doesn't work(it
puts
"0"or the result is 1) but if i write it manually (so without a formule
of
difference) it works.
I solve temporatly the problem with a by pass(2 others colonnes where i
put
a example of diff (IF(A1Á;1;0)and C1 is a fix cell with the same kind
of
diff so 14-13.3 and then it works) but i can't understand why with number
without "," it works(ex:1 2 3 ...) and with the number with "," it
doesn't
works.
Could you say something about that?
Bonjour Pierre Moi ça me rappelle un fameux dialogue : - "tea for two and two for tea...." - "You are ?" - "Are you ?"
:-)))
Cordialement Pascal
"Pierre Fauconnier" a écrit dans le message de news:
Hello..
1. Say "Hello" 2. Say "Thanks for the help" 3. Speak french because tis newsgroup is Microsoft.public.FR.excel
I think your problem is that B2-B1 <> 0.7. It could be 0.7000000000001 and this answer <> 0.7 You can have a solution with round(B2-B1;1) in your formula.
Ok?
-- Pierre Fauconnier () "Le bonheur n'est pas au bout du chemin. Le bonheur EST le chemin ( proverbe zen ) Remplacez nospam.nospam par pfi.be pour répondre. Merci
"" @discussions.microsoft.com> a écrit dans le message de news:
So, when i made a formule for example "=IF(A1=0.7;1;0)" and the 0.7 come from a difference of 2 other cells example B2-B1(=0.7); It doesn't work(it puts "0"or the result is 1) but if i write it manually (so without a formule of difference) it works. I solve temporatly the problem with a by pass(2 others colonnes where i put a example of diff (IF(A1Á;1;0)and C1 is a fix cell with the same kind of diff so 14-13.3 and then it works) but i can't understand why with number without "," it works(ex:1 2 3 ...) and with the number with "," it doesn't works. Could you say something about that?
Pierre Fauconnier
Isn't it ?
Pierre
"papou" <cestpasbon@çanonplus44.fr> a écrit dans le message de news: %
Bonjour Pierre Moi ça me rappelle un fameux dialogue : - "tea for two and two for tea...." - "You are ?" - "Are you ?"
:-)))
Cordialement Pascal
"Pierre Fauconnier" a écrit dans le message de news:
Hello..
1. Say "Hello" 2. Say "Thanks for the help" 3. Speak french because tis newsgroup is Microsoft.public.FR.excel
I think your problem is that B2-B1 <> 0.7. It could be 0.7000000000001 and this answer <> 0.7 You can have a solution with round(B2-B1;1) in your formula.
Ok?
-- Pierre Fauconnier () "Le bonheur n'est pas au bout du chemin. Le bonheur EST le chemin ( proverbe zen ) Remplacez nospam.nospam par pfi.be pour répondre. Merci
"" @discussions.microsoft.com> a écrit dans le message de news:
So, when i made a formule for example "=IF(A1=0.7;1;0)" and the 0.7 come from a difference of 2 other cells example B2-B1(=0.7); It doesn't work(it puts "0"or the result is 1) but if i write it manually (so without a formule of difference) it works. I solve temporatly the problem with a by pass(2 others colonnes where i put a example of diff (IF(A1Á;1;0)and C1 is a fix cell with the same kind of diff so 14-13.3 and then it works) but i can't understand why with number without "," it works(ex:1 2 3 ...) and with the number with "," it doesn't works. Could you say something about that?
Isn't it ?
Pierre
"papou" <cestpasbon@çanonplus44.fr> a écrit dans le message de news:
%23kycOGvWFHA.2448@TK2MSFTNGP10.phx.gbl...
Bonjour Pierre
Moi ça me rappelle un fameux dialogue :
- "tea for two and two for tea...."
- "You are ?"
- "Are you ?"
:-)))
Cordialement
Pascal
"Pierre Fauconnier" <pierre.fauconnier@nospam.nospam> a écrit dans le
message de news: OGKvW2sWFHA.2540@tk2msftngp13.phx.gbl...
Hello..
1. Say "Hello"
2. Say "Thanks for the help"
3. Speak french because tis newsgroup is Microsoft.public.FR.excel
I think your problem is that B2-B1 <> 0.7. It could be 0.7000000000001
and this answer <> 0.7
You can have a solution with round(B2-B1;1) in your formula.
Ok?
--
Pierre Fauconnier (pierre.fauconnier@nospam.nospam)
"Le bonheur n'est pas au bout du chemin. Le bonheur EST le chemin (
proverbe zen )
Remplacez nospam.nospam par pfi.be pour répondre. Merci
"christophemiroir@yahoo.fr"
<christophemiroir@yahoo.fr@discussions.microsoft.com> a écrit dans le
message de news: 8AE1AC7D-910F-4251-BD0A-B46985990267@microsoft.com...
So, when i made a formule for example "=IF(A1=0.7;1;0)" and the 0.7 come
from
a difference of 2 other cells example B2-B1(=0.7); It doesn't work(it
puts
"0"or the result is 1) but if i write it manually (so without a formule
of
difference) it works.
I solve temporatly the problem with a by pass(2 others colonnes where i
put
a example of diff (IF(A1Á;1;0)and C1 is a fix cell with the same kind
of
diff so 14-13.3 and then it works) but i can't understand why with
number
without "," it works(ex:1 2 3 ...) and with the number with "," it
doesn't
works.
Could you say something about that?
"papou" <cestpasbon@çanonplus44.fr> a écrit dans le message de news: %
Bonjour Pierre Moi ça me rappelle un fameux dialogue : - "tea for two and two for tea...." - "You are ?" - "Are you ?"
:-)))
Cordialement Pascal
"Pierre Fauconnier" a écrit dans le message de news:
Hello..
1. Say "Hello" 2. Say "Thanks for the help" 3. Speak french because tis newsgroup is Microsoft.public.FR.excel
I think your problem is that B2-B1 <> 0.7. It could be 0.7000000000001 and this answer <> 0.7 You can have a solution with round(B2-B1;1) in your formula.
Ok?
-- Pierre Fauconnier () "Le bonheur n'est pas au bout du chemin. Le bonheur EST le chemin ( proverbe zen ) Remplacez nospam.nospam par pfi.be pour répondre. Merci
"" @discussions.microsoft.com> a écrit dans le message de news:
So, when i made a formule for example "=IF(A1=0.7;1;0)" and the 0.7 come from a difference of 2 other cells example B2-B1(=0.7); It doesn't work(it puts "0"or the result is 1) but if i write it manually (so without a formule of difference) it works. I solve temporatly the problem with a by pass(2 others colonnes where i put a example of diff (IF(A1Á;1;0)and C1 is a fix cell with the same kind of diff so 14-13.3 and then it works) but i can't understand why with number without "," it works(ex:1 2 3 ...) and with the number with "," it doesn't works. Could you say something about that?
RT
Zut! Comment Zut? But you are French?
You are not english?
Il y a des moments comme ça dans la vie ou quoi que l'on fasse il y a toujours quelqu'un pour vous rappeller un bon moment du passé
Merci
Rex
"papou" <cestpasbon@çanonplus44.fr> wrote in message news:#
Bonjour Pierre Moi ça me rappelle un fameux dialogue : - "tea for two and two for tea...." - "You are ?" - "Are you ?"
:-)))
Cordialement Pascal
"Pierre Fauconnier" a écrit dans le message de news:
Hello..
1. Say "Hello" 2. Say "Thanks for the help" 3. Speak french because tis newsgroup is Microsoft.public.FR.excel
I think your problem is that B2-B1 <> 0.7. It could be 0.7000000000001 and
this answer <> 0.7 You can have a solution with round(B2-B1;1) in your formula.
Ok?
-- Pierre Fauconnier () "Le bonheur n'est pas au bout du chemin. Le bonheur EST le chemin ( proverbe zen ) Remplacez nospam.nospam par pfi.be pour répondre. Merci
"" @discussions.microsoft.com> a écrit dans le message de news:
So, when i made a formule for example "=IF(A1=0.7;1;0)" and the 0.7 come
from a difference of 2 other cells example B2-B1(=0.7); It doesn't work(it puts "0"or the result is 1) but if i write it manually (so without a formule of difference) it works. I solve temporatly the problem with a by pass(2 others colonnes where i put a example of diff (IF(A1Á;1;0)and C1 is a fix cell with the same kind of diff so 14-13.3 and then it works) but i can't understand why with number
without "," it works(ex:1 2 3 ...) and with the number with "," it doesn't works. Could you say something about that?
Zut!
Comment Zut?
But you are French?
You are not english?
Il y a des moments comme ça dans la vie ou quoi que l'on fasse
il y a toujours quelqu'un pour vous rappeller un bon moment du passé
Merci
Rex
"papou" <cestpasbon@çanonplus44.fr> wrote in message
news:#kycOGvWFHA.2448@TK2MSFTNGP10.phx.gbl...
Bonjour Pierre
Moi ça me rappelle un fameux dialogue :
- "tea for two and two for tea...."
- "You are ?"
- "Are you ?"
:-)))
Cordialement
Pascal
"Pierre Fauconnier" <pierre.fauconnier@nospam.nospam> a écrit dans le
message de news: OGKvW2sWFHA.2540@tk2msftngp13.phx.gbl...
Hello..
1. Say "Hello"
2. Say "Thanks for the help"
3. Speak french because tis newsgroup is Microsoft.public.FR.excel
I think your problem is that B2-B1 <> 0.7. It could be 0.7000000000001
and
this answer <> 0.7
You can have a solution with round(B2-B1;1) in your formula.
Ok?
--
Pierre Fauconnier (pierre.fauconnier@nospam.nospam)
"Le bonheur n'est pas au bout du chemin. Le bonheur EST le chemin (
proverbe zen )
Remplacez nospam.nospam par pfi.be pour répondre. Merci
"christophemiroir@yahoo.fr"
<christophemiroir@yahoo.fr@discussions.microsoft.com> a écrit dans le
message de news: 8AE1AC7D-910F-4251-BD0A-B46985990267@microsoft.com...
So, when i made a formule for example "=IF(A1=0.7;1;0)" and the 0.7
come
from
a difference of 2 other cells example B2-B1(=0.7); It doesn't work(it
puts
"0"or the result is 1) but if i write it manually (so without a formule
of
difference) it works.
I solve temporatly the problem with a by pass(2 others colonnes where i
put
a example of diff (IF(A1Á;1;0)and C1 is a fix cell with the same kind
of
diff so 14-13.3 and then it works) but i can't understand why with
number
without "," it works(ex:1 2 3 ...) and with the number with "," it
doesn't
works.
Could you say something about that?
Il y a des moments comme ça dans la vie ou quoi que l'on fasse il y a toujours quelqu'un pour vous rappeller un bon moment du passé
Merci
Rex
"papou" <cestpasbon@çanonplus44.fr> wrote in message news:#
Bonjour Pierre Moi ça me rappelle un fameux dialogue : - "tea for two and two for tea...." - "You are ?" - "Are you ?"
:-)))
Cordialement Pascal
"Pierre Fauconnier" a écrit dans le message de news:
Hello..
1. Say "Hello" 2. Say "Thanks for the help" 3. Speak french because tis newsgroup is Microsoft.public.FR.excel
I think your problem is that B2-B1 <> 0.7. It could be 0.7000000000001 and
this answer <> 0.7 You can have a solution with round(B2-B1;1) in your formula.
Ok?
-- Pierre Fauconnier () "Le bonheur n'est pas au bout du chemin. Le bonheur EST le chemin ( proverbe zen ) Remplacez nospam.nospam par pfi.be pour répondre. Merci
"" @discussions.microsoft.com> a écrit dans le message de news:
So, when i made a formule for example "=IF(A1=0.7;1;0)" and the 0.7 come
from a difference of 2 other cells example B2-B1(=0.7); It doesn't work(it puts "0"or the result is 1) but if i write it manually (so without a formule of difference) it works. I solve temporatly the problem with a by pass(2 others colonnes where i put a example of diff (IF(A1Á;1;0)and C1 is a fix cell with the same kind of diff so 14-13.3 and then it works) but i can't understand why with number
without "," it works(ex:1 2 3 ...) and with the number with "," it doesn't works. Could you say something about that?
