Results 1 to 9 of 9
  1. #1
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: If formula (Excel 2000)

    What should the formula return if G12 is greater than or equal to 3? The following will return 19.95 if G12 is less than 3 and null if G12 is Greater Than or Equal to 3.

    <pre>=IF(G12<3,19.95,"")
    </pre>

    Legare Coleman

  2. #2
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    Paragould, Arkansas, USA
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: If formula (Excel 2000)

    Stan,
    There's many, many formulas available in Excel. Excel has a nifty way to help you in choosing the best one, and to help out if you know a formula, but you're not sure of the syntax.

    To start, in a given cell you'd line a formula, just type an = equals sign. Now look to the left of the formula bar (where you can edit your cells), you'll see the name of a function (it might look greyed out but it isn't). That's a drop down box that will give you access to any function in Excel. Choose a function there, and the formula palette will appear, which gives you "live" results and helps you fill in the correct syntax. If you type <font face="Georgia">=if</font face=georgia> then click on that bold = equals sign, the formula palette for working out the IF function will appear.

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Swift Current, Sask. Canada, Saskatchewan, Canada
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    If formula (Excel 2000)

    <P ID="edit" class=small>(Edited by S Peters on 14-Jan-04 10:01. more info)</P>I'm not very familiar with Excel, but am trying to learn. I am trying to find a formula where if say G12 is less than 3, it should show 19.95. g12 is a sum of another 2 cells. I am attaching an example of what I am doing. The message I got from Legare Coleman keeps giving me an error, so maybe he needed to see what I was doing. I have tried using Excels formulas, but was unable to figure out just what they needed.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: If formula (Excel 2000)

    If someone has already replied, and you have further questions and/or additional information, it is better to post a reply. Editing the original post may confuse Loungers who read this thread later on, and you run the risk that it escapes the attention of whoever replied, because your reaction is higher up in the thread than the reply you react to.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: If formula (Excel 2000)

    You hadn't told us that you are dealing with time values. Try this formula:

    =IF(G12<TIME(3,0,0),19.95,"")

    The Time function takes a number of hours, minutes and seconds and returns the corresponding time value. You will probably have to clear the time formatting Excel automatically applies to the result of the above formula (Edit | Clear | Formats)

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: If formula (Excel 2000)

    Sorry, I missed that you edited the original message rather than replying to my message. You didn't say that you were dealing with time values which introduces a different wrinkle. I am still not clear what you want to display in the blue cell. That cell is formatted as time, so if the formula returns 19.95 it will display as 22:48 (.95 of a day). Hans has given you a formula that will work with a time value in G12 and will return 19.95 if G12 is less than 3 hours and null if it is greater than or equal to. However, this will display as 22:48. If you want it to display as 19.95, you will also have to change the cell format of column H.
    Legare Coleman

  7. #7
    Star Lounger
    Join Date
    Jan 2001
    Location
    Swift Current, Sask. Canada, Saskatchewan, Canada
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: If formula (Excel 2000)

    The formula you gave me keeps giving me an error message. I was unable to clear format of results, because I couldn't get results because of the error message. The blue cell I was wanting to display currency ( H column)

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: If formula (Excel 2000)

    Does the attached modified version of your workbook work?

  9. #9
    Star Lounger
    Join Date
    Jan 2001
    Location
    Swift Current, Sask. Canada, Saskatchewan, Canada
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: If formula (Excel 2000)

    That is exactly what I want. Now I guess I need to formulate the rest of the cells in H to show nothing if they are zero or above 3. Thank you for your help.

Posting Permissions

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