+ Reply to Thread
Results 1 to 4 of 4

IF greater or equal then formula without using data validation

  1. #1
    Registered User
    Join Date
    06-27-2015
    Location
    Las Vegas
    MS-Off Ver
    2010
    Posts
    5

    IF greater or equal then formula without using data validation

    I am trying to create a simple formula without using a data validation list.

    1. Is it possible
    2. If NOT how do you create in data validation

    I have tried this formula inside and outside of data validation, Googled till my fingers bled and can't find what I am looking for.

    A17= Number 1 or higher
    Statement tried but receive an error

    =IF(A17>=25,"24.95","34.95")

    My goal is IF A = 25 or greater then price is 24.95, If False then 34.95

    Thanks in Advance

  2. #2
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: IF greater or equal then formula without using data validation

    Quote Originally Posted by nstcctv View Post

    A17= Number 1 or higher
    Statement tried but receive an error

    =IF(A17>=25,"24.95","34.95")
    What error do you get?

    Don't quote numbers:

    =IF(A17>=25,24.95,34.95)

    Quoting numbers turns them into TEXT strings!
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    06-27-2015
    Location
    Las Vegas
    MS-Off Ver
    2010
    Posts
    5

    Re: IF greater or equal then formula without using data validation

    Disregard. I tried data validation first and did not clear the data before trying as a formula.

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: IF greater or equal then formula without using data validation

    Hi,

    You can't have a formula in a cell and also expect that cell to end up with a value that's determined by whatever formula is in that cell. The cell can only contain either a constant value or a formula. You could use a helper cell other than A17 with a formula to evaluate A17. Otherwise you would need a macro. e.g.
    Please Login or Register  to view this content.
    Data validation can only be used for determining whether Excel will accept an entry, it can't modify an entry.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Greater than or Equal to Formula
    By alexanderdeluna in forum Excel General
    Replies: 2
    Last Post: 02-19-2014, 09:40 PM
  2. Greater Than - Less Than - Equal to.... formula help
    By dhue0715 in forum Excel General
    Replies: 7
    Last Post: 01-10-2012, 08:28 PM
  3. Formula for greater than or equal to
    By jsfisher in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-08-2009, 11:50 AM
  4. Excel 2007 : Formula Greater than or Equal
    By UnknownState in forum Excel General
    Replies: 2
    Last Post: 04-21-2009, 09:17 PM
  5. adding equal/greater than into formula
    By rvnwdr in forum Excel General
    Replies: 2
    Last Post: 09-23-2005, 06:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1