Results 1 to 9 of 9
Thread: If formula (Excel 2000)

20040113, 04:09 #1
 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

20040113, 05:34 #2
 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.

20040114, 16:01 #3
 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 14Jan04 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.

20040114, 16:09 #4
 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.

20040114, 16:17 #5
 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)

20040114, 18:48 #6
 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

20040114, 22:54 #7
 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)

20040114, 23:16 #8
 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?

20040115, 03:38 #9
 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.