Formula to find cells with vlaues between 95s and 100s and 100s and 105s

  • Hi!


    I need 2 formulae, one to find cells with values between 95s and 100s such as between 195 and 200, 295 and 300, 1195 and 1200 etc. and scond to find cells with values between 100s and 105s such as between 200 to 205, 1200 to 1205 etc.


    Please note that the cell values will be in 2 decimal places, such as 195.94, 1195.30, 1205.30 etc.


    The solution may please be checked with values such as 430.95, 150 etc. since I tried dividing the cell values by 100 and rounding off to zero decimal, but then excel treats values such as .30 as .3 and I was getting false results.


    Thanks,


    Naira

  • Re: Formula to find cells with vlaues between 95s and 100s and 100s and 105s


    Do you want the remaining values, or just True or False to display whether or not the cell contains such a value?


    =MOD(A1,100)>95
    =MOD(A1,100)<5


    Or similar.

    [COLOR="Purple"]Regards,[/COLOR]
    [COLOR="Purple"]Batman.[/COLOR]

  • Re: Formula to find cells with vlaues between 95s and 100s and 100s and 105s


    Hi Batman!
    Your solution works as required.
    True/ False is ok with me, I can pick up from there.
    Thanks for the help.


    Naira

Participate now!

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