Comparing long numbers.

[mr_samd]

I have a test which is to see if people can correctly caluclate Log10s propperly.
I have excel working it out in hidden cells. I want a cell to say "Pass" if they type the correct answer in or "Fail" if not.
I have done this ( =IF(A1=A2,"PASS","FAIL")) and it all works, as long as you type in all the decimal points. This is obviously a pain for users.
Is there a way i can get it to "pass" if they only type up to, say 4 decimal points?

Any help would be appreciated!

Thanks

Sam

 

[Joe4]

Try this:

[COLOR=#333333]=IF(ROUND(A1,4)=ROUND(A2,4),"PASS","FAIL"))[/COLOR]

 

[mr_samd]

That worked great thanks!

 

[Joe4]

You are welcome.