PLEASE HELP! Student in need of advice about an Excel formula.

[BAILEY1234]

Hi Guys.

I am a student and certainly not an expert in Excel. It would be greatly appreciated if someone could help me with this issue.

What I would actually like to do is from a column of data be able to pick out those that have more than 2 decimal places, or 3 decimal places.

I would like to write a formula that acts like an IF statement. So if the given cell contains a value with >2dp / >3dp then it would like flag up and I could see it quickly.

Is this possible? Can someone explain this to me in rather simple terms?

Thanks
Ryan

 

[pedie]

did you try something like this?
=LEN(A1)-(FIND(".",A1,1))
this is to return a decimal count from text val cell (A1) .

 

[BAILEY1234]

did you try something like this?
=LEN(A1)-(FIND(".",A1,1))
this is to return a decimal count from text val cell (A1) .

Hey Pedie,

Thanks a lot for your response.

I tried what you said above but am getting an error message - Says i've entered "too few arguments for this function"

Do I need any value in the (".") bit?

Would be great if it could tell me which values in the column or even how many values from the column have more than 2 decimal places.

Thanks
Ryan

 

[diddi]

not sure if it makes any difference, but try this:

    =LEN(A1)-FIND(".",A1,1)

put it in B1, and fill down your column.

you can use a countif formula to see how many there are. (try MSHelp in excel for examples of countif)