Results 1 to 4 of 4

Thread: Formula for when a number is greater than or less than by a certain value

  1. #1
    New Member
    Join Date
    Oct 2018
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Formula for when a number is greater than or less than by a certain value

    Hello all

    I am stuck with what seems a fairly simple thing to do but my tiny brain has given up now.

    So I want to create an IF statement to work out IF a value in the same column is less than another value in the same column by 2, 3, 4 etc., any number really.

    so my column looks like this:

    2.84
    3.85
    5.00
    13.50

    What I want to do is when the second number in this case 3.85 is less than the third number 5.00 by 2

    I can't seem to figure it out for the life of me.

    Any ideas

    The numbers will always be in the one column.

  2. #2
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,261
    Post Thanks / Like
    Mentioned
    72 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Formula for when a number is greater than or less than by a certain value

    Do you need something like this?

     BC
    22.84no
    33.85no
    45.00is less by 2
    513.50no

    CellFormula
    C2=IF(B2<B3-2,"is less by 2","no")
    Last edited by DanteAmor; Sep 7th, 2019 at 08:02 AM.
    Regards Dante Amor

  3. #3
    New Member
    Join Date
    Oct 2018
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula for when a number is greater than or less than by a certain value

    That really works thank you.

    I did have that kind of idea but it just seemed way too simple.

    Thanks again

    Paul

  4. #4
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,261
    Post Thanks / Like
    Mentioned
    72 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Formula for when a number is greater than or less than by a certain value

    I'm glad to help you. Thanks for the feedback.
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •