Roundup and IF Formula

  • 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

  • Re: Roundup and IF Formula


    Try
    [COLOR="#0000FF"]
    =IF(ROUNDUP(A2,2)=B2,"YES","NO")[/COLOR]

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!