I am trying to compare two columns of numerical data to see if they match but one is a number that goes to multiple decimal places and the other goes to two decimal places e.g. -1.305 and -1.31 I want to try and combine an if statement and a roundup statement is this possible ? I would like it to look at the first cell and roundup to 2 decimal places then compare that to the other cell and if matches says yes if not No I have tried it several ways but cannot get it to work thank you in advance to anyone that can help
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!