Excel IF condition with comma
Solved
informatifien
Posted messages
781
Status
Membre
-
informatifien Posted messages 781 Status Membre -
informatifien Posted messages 781 Status Membre -
Hello hello,
Here's just a quick question, is there a formula to say if A1 has a number after the decimal point then display 1?
Basically, I display numbers which will either be or not be 0.5, if so I would like 1 in A2, if not I would like 0, I tried this: =IF(A1="#,5",1,0) but it shows 0, I think there's a syntax problem with the 0.5...
If anyone has an idea.
Thanks in advance
--
THANK YOU TO CCM FOR DECLARING PUBLIC INTEREST SOURCE... PLEASE MARK YOUR RESOLVED TOPICS WHEN IT'S THE CASE...
Here's just a quick question, is there a formula to say if A1 has a number after the decimal point then display 1?
Basically, I display numbers which will either be or not be 0.5, if so I would like 1 in A2, if not I would like 0, I tried this: =IF(A1="#,5",1,0) but it shows 0, I think there's a syntax problem with the 0.5...
If anyone has an idea.
Thanks in advance
--
THANK YOU TO CCM FOR DECLARING PUBLIC INTEREST SOURCE... PLEASE MARK YOUR RESOLVED TOPICS WHEN IT'S THE CASE...
Configuration: asus P5V800 / P4 2.8 Ghz / 1.5 Go Windows XP FireFox / IE 7
2 réponses
Hello
You can't do it with your formula because you're using a format and not a value, but you have plenty of other options.
for example
You might not need your column because you can then write
--
Always zen
You can't do it with your formula because you're using a format and not a value, but you have plenty of other options.
=IF(A1-INT(A1)=0,0,1) or =IF(MOD(A1,1)=0,0,1) or =IF(A1=INT(A1),0,1) or =IF(MOD(A1,1),1,0)
for example
You might not need your column because you can then write
=IF(MOD(A1,1),"decimal","integer")
--
Always zen
