Skip to main content
ARE YOU A BUSINESS?

Post content has been hidden

To unblock this content, please click here

Mrs Vineweevil
Beginner

Excel Help Please.....?

Mrs Vineweevil, 15 August, 2008 at 15:36 Posted on Off Topic Posts 0 4
Saved
Reply

I have the following (Simplified Version)

Cell A1 = 41.56

Cell A2 = 41.32

Cell A3 = I want to put here that if the difference between A1 and A2 is between 1 and -1 then "OK", otherwise, "ERROR MESSAGE..."

Any ideas..... Iknow it is a friday....?

4 replies

Latest activity by Oh Zippy, 15 August, 2008 at 23:29
  • O
    Beginner
    Oh Zippy ·
    • Report
    • Hide content

    It's basically

    =IF ( logical_test, value_if_true, value_if_false )

    so in A3 it would be something like

    =IF((A1-A2=-1);"ok", "error")

    • Reply
  • O
    Beginner
    Oh Zippy ·
    • Report
    • Hide content

    Sorry, I've just read your post again and have seen it needs to be a range. Hang on a sec, I'll have another go ?

    • Reply
  • O
    Beginner
    Oh Zippy ·
    • Report
    • Hide content

    =IF(A1-A2>=-1;IF(A1-A2<=1;"ok";"error");"error")

    I think ?

    • Reply
  • X
    Beginner August 2006
    Xarra ·
    • Report
    • Hide content

    I think it's:

    =IF(AND(A1-A2<=1, A1-A2>=-1), "OK", "Error")

    OZ - I can't get yours to work...

    • Reply
  • O
    Beginner
    Oh Zippy ·
    • Report
    • Hide content
    View quoted message

    It quite possibly doesn't - I don't have Excel on my machine so was doing it from memory without testing it.

    I'm kind of guessing that the need for the solution has passed now anyway ?

    • Reply

You voted for . Add a comment 👇

×


Related articles

Ask Elektra: Being a Bridesmaid is Taking Over My Life - Help!
Planning Essentials Ask Elektra: Being a Bridesmaid is Taking Over My Life -... In this month's drag-ony aunt column, a bridesmaid in distress asks Aunty...
11 Beauty Editor-Approved Sleep Products to Help You Drift Off Before Your Wedding
Beauty and Wellbeing 11 Beauty Editor-Approved Sleep Products to Help You Drift... Not being able to sleep is one of the worst feelings - especially when you’re...
Read more articles

Premium members

  • Q
    Qa Test I got married in August - 2022 North Yorkshire

General groups

Show more

Hitched article topics

Contest icon

Win £3,000 for your wedding

Join Hitched Rewards, where you can win £3,000 simply by planning your wedding with us. Start collecting entries, it's easy and free!

Enter now