A simple IF statement fails me

[Jody]

I've looked around the site and can't find what works to correct my IF statement so I apologize in advance if this is a repeat question.


This is my formula. =IF(I4="Sandanona",G4*0.01,G4)


cell I4 says sandanona but I'm not getting the True answer I'm getting the false answer.

 

[fred]

make sure there is no extra space in I4. if it is "sandanona " then it is not the same as "sandanona".

 

[Luke M]

Double check I4, make sure there aren't any extra spaces before or after the text that could be throwing things off.

 

[Kamarlon]

Make sure the word sandanona is spelled correctly. That could be a problem

 

[oldchippy]

Also check for upper and lower case


"Sandanona" not same as "sandanona"

 

[fred]

Upper case and lower case has no effect in a if statement.

 

[Luke M]

I believe within Excel's formulas, case comparison it not usually an issue. Exception would be with the FIND function. It's usually more of a pain w/ VB functions (which are all case-sensitive).

 

[NARAYANK991]

Hi Jody ,


I copied your formula , and used "sandanona" in I4 ; it gives the correct result i.e. G4 * 0.01.


Why don't you just copy the Sandanona from your formula into cell I4 ; that will almost eliminate all possibilities ?


Narayan