1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Formula Difficulty

Discussion in 'Business Applications' started by Csmith12, Mar 12, 2019.

Thread Status:
Not open for further replies.
  1. Csmith12

    Csmith12 Thread Starter

    Joined:
    Mar 12, 2019
    Messages:
    1
    Hi all,

    Hope I've posted this in the right place - I will try to be as straight forward as possible with my question..

    I have a spreadsheet that is using the VLOOKUP formula (which I want to keep). Once Excel has done it's thing with the existing formula, I would like it to tell me if the result is equal to, below, or above a target - the calculation and the targets are text (and I need them to stay that way). Could anyone advise, in really simple instructions (sorry), how I might go about this? I can attach a sample of the spreadsheet.

    I feel like it might be really simple but I've been frying my brain with other formulas on other spreadsheets so I'm looking at this one with a tired pair of eyes and slower brain!

    Thanks so much in advance! Appreciate any replies.
     
  2. SpywareDr

    SpywareDr

    Joined:
    Mar 30, 2014
    Messages:
    3,323
    =IF(A1>B1, "A1>B1", IF(A1=B1, "A1=B1", IF(A1<B1, "A1<B1", "")))

    ?
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1224343

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice