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.

Solved: Help with IF formula

Discussion in 'Business Applications' started by quiff, Feb 17, 2015.

Thread Status:
Not open for further replies.
Advertisement
  1. quiff

    quiff Thread Starter

    Joined:
    Jan 28, 2015
    Messages:
    12
    Hi,


    Trying to get this formula to work but does not seem to want to.


    =IF(A1>0,"2.4m",+IF(A1<2401,"3.6m",0))


    So basically I want A2 to display two different types of information. If A1 is greater than 0, display 2.4m. If A1 is greater than 2400, display 3.6m. If not then 0.


    But all I get is 2.4m even though the number is greater than 2400.


    Thanks in advance
     
  2. cwwozniak

    cwwozniak Trusted Advisor Spam Fighter

    Joined:
    Nov 28, 2005
    Messages:
    64,238
    First Name:
    Chuck
    The way you have the formula written, any number greater than zero will result in a TRUE result for the first IF() test and never gets to the second IF() test. See if the following gives you the desired results:

    Code:
    =IF(A1>2400,"3.6m",IF(A1>0,"2.4m",0))
    EDIT: The above information applies to MS-Excel. Not sure how to solve the problem if you are using a different spreadsheet application.
     
  3. quiff

    quiff Thread Starter

    Joined:
    Jan 28, 2015
    Messages:
    12
    thanks a lot your a genius
     
  4. cwwozniak

    cwwozniak Trusted Advisor Spam Fighter

    Joined:
    Nov 28, 2005
    Messages:
    64,238
    First Name:
    Chuck
    You're welcome.
     
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/1143278

  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