IF Formula #8

I am trying to create an IF formula. I want the column C to yield "Yes" if 
the value in column A is plus or minus 3 of the value in column B and yield 
"No" if not. Example of my data:

A	B	C
40	37	Yes
20	22	Yes
30	34	No
50	45	No

How would I achieve this?

Thanks!
0
LDanix (8)
1/11/2005 10:45:10 PM
excel.misc 78881 articles. 5 followers. Follow

4 Replies
444 Views

Similar Articles

[PageSpeed] 49

=IF(ABS(A1-B1)<=3,"Yes","No")

0
CycleZen (674)
1/11/2005 10:50:40 PM
Try this

=IF(ABS(A1-B1)<=3,"Yes","No")

-- 

HTH

RP
(remove nothere from the email address if mailing direct)


"LDanix" <LDanix@discussions.microsoft.com> wrote in message
news:7295BC2C-8CBA-4230-8342-4BD3E5B25B98@microsoft.com...
> I am trying to create an IF formula. I want the column C to yield "Yes" if
> the value in column A is plus or minus 3 of the value in column B and
yield
> "No" if not. Example of my data:
>
> A B C
> 40 37 Yes
> 20 22 Yes
> 30 34 No
> 50 45 No
>
> How would I achieve this?
>
> Thanks!


0
bob.phillips1 (6510)
1/11/2005 11:32:05 PM
On Tue, 11 Jan 2005 23:32:05 -0000, "Bob Phillips"
<bob.phillips@notheretiscali.co.uk> wrote:

>Try this
>
>=IF(ABS(A1-B1)<=3,"Yes","No")

Hi,

In (ABS... what is the S in this formula?

Thanks.
0
smdiydli (5)
1/12/2005 6:03:46 AM
What do you mean> ABS is a worksheet function that returns the absolute
value of a number.

-- 

HTH

RP
(remove nothere from the email address if mailing direct)


"SMD" <smdiydli@aol.com> wrote in message
news:scf9u0pu82ptb3h59qkjked32835rkvcot@4ax.com...
> On Tue, 11 Jan 2005 23:32:05 -0000, "Bob Phillips"
> <bob.phillips@notheretiscali.co.uk> wrote:
>
> >Try this
> >
> >=IF(ABS(A1-B1)<=3,"Yes","No")
>
> Hi,
>
> In (ABS... what is the S in this formula?
>
> Thanks.


0
bob.phillips1 (6510)
1/12/2005 9:47:55 AM
Reply:

Similar Artilces:

help with formula #9
G12 has a dropdown menu in it, Y for YES, N for NO. I12 is where the answers will go. So if I pick N from the dropdown box in G12 , I need it to show a answer of 0 in I12. If I choose Y in cell G12 , I need it to use this formula =Roundup(E12/300,0) so that it will give me a answer in cell I12. How to I write this and get it to work? Place in I12: =IF(G12="Y",ROUNDUP(E12/300,0),0) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Art" wrote: > G12 has a dropdown menu in it, Y for YES, N for NO. > I12 is where the answers will go. > So if ...

I need a formula for a Golf Scorecard
If the value of column B is greater by 2 than the value of column A, Record as 1 in column C. enter in C2 =IF(B2-A2>2,1,"") and copy down -- Greetings from New Zealand Bill K "Timmy" <Timmy@discussions.microsoft.com> wrote in message news:1A8710C9-50BC-4B5D-8197-81EA2D8AC1F8@microsoft.com... > If the value of column B is greater by 2 than the value of column A, > Record > as 1 in column C. Thanks for your help Bill, Im in NZ too!!! Unfortunatly your formula did not work. It doesnt show up as invalid but just turns up a blank(not a zero even) in ...

using calculation in worksheet as formula
Hi, I am creating a business model for an Internet portal. Obviously I used Excel to create this model, unfortunately I ran into the following problem. I created a worksheet that calculates the turnover in a couple of steps. The main input variable is the number of portal members. In a second sheet I made a prognosis of the number of members for the upcoming 3 years (per month). Now I want excel to calculate the turnover per month using the calculation in the turnover sheet. I have no clue how to do this. I assume it can be solved using VBA but I prefer to keep the worksheet with the calcu...

I need a formula!!!
I am working in Excel 2000 and I have a spreedsheet already made but i have to make a new one and I have 4 colums of information that I would like to move into one colum can you help me with the formula? Krystin Use =Cell1&Cell2&Cell3&Cell4 If you require spaces in between each cell entry use =Cell1&" "&Cell2&" " etc Andy. "Krystin" <ext-krystin.craig@nokia.com> wrote in message news:3af201c3761f$d2de8cd0$a301280a@phx.gbl... > I am working in Excel 2000 and I have a spreedsheet > already made but i have to make a new one ...

Econnect failing after upgrade to 8.0.3
We had been using 8.0.0.0, but after talking with support about and issue.. we were told to upgrade to the newest version. Now I'm getting the below message and it finally erros out. Has anyone else had this problem? Please help The adapter failed to transmit message going to send port "data source=172.16.21.209;initial catalog=ABC;integrated security=SSPI;persist security info=False;packet size=4096". It will be retransmitted after the retry interval specified for this Send Port. Details:" MessageID:00078fb1-84de-4073-aa81-897804607b5c System.Data.SqlClient.SqlExcepti...

formula when clicked on gets information form a percifice cell.
-- Robert What's a "percifice" cell? Regards, Fred "Trebor" <Trebor@discussions.microsoft.com> wrote in message news:10BB9ACA-C9A5-480D-9C3C-8026497BE209@microsoft.com... > > -- > Robert What is your question? Otto "Trebor" <Trebor@discussions.microsoft.com> wrote in message news:10BB9ACA-C9A5-480D-9C3C-8026497BE209@microsoft.com... > > -- > Robert Clicking on a formula will get you nothing? What do you want to do? Gord Dibben MS Excel MVP On Sun, 15 Nov 2009 02:30:01 -0800, Trebo...

Formula #61
I would like to know procedure for multipling a currency against a time format I think you'll have to provide an example. Perhaps $20 x 3:00 (3 hours, where the formula bar shows 3 AM as the time), you can use: =A1*(B1*24) ************ Anne Troy www.OfficeArticles.com "laksmi" <laksmi@discussions.microsoft.com> wrote in message news:F906404B-11F6-44C4-8373-2EBB9CB6C7AC@microsoft.com... >I would like to know procedure for multipling a currency against a time >format ...

copy and paste all but formulas
i have a large spread sheet that I use to gather and process many customer's information. I need a way to copy and paste items from that spreadsheet and not copy the formulas. I could copy just the values but then I lose all the wonderful formatting. For information security reasons I need to be able to copy all values formatting, borders, etc... and leave out the formulas. Can this be done? Thanks, Steven Farrar Farrar digital Solutions Hi Copy the Data>Paste Special>Values followed immediately by Paste Special>Formats. -- Regards Roger Govier <stevenfarrar@gma...

subtotals and formulas
I would like to set-up a template to track supplies and amounts paid. Row 1 would have the job # and the various supplies while I want row 2, right under each supply, to indicate how much that particular item costs. I will then sort the supplies by job number. I've encountered two problems: 1). The subtotal function will not allow me to subtotal with the prices in row 2. Anyway around this short of actually hiding row 2? 2). I want formulas already set-up on my template to calculate the grand total of each particular supply, multiplied by cost per item. However, when I do that, the f...

What formula/function can I use?
I'm creating a spreadsheet for a client and I'm not sure what formula/function I need to do this: I created a table with over 500 available values. I then created (on a separate sheet) a form to input the customers information. 4 pieces of the customer's information need to be used to figure out the correct price - Age, Tobacco or No, Male or Female, and amount of coverage. I need to be able to reference the right cell in my table according to how the 4 above criteria are met, and plug that value back on to my customer information page to show the customer their cost for c...

Urgently need help with creating formulas
Hello My worksheet is full of thousands of firstnames, middle names surnames, email addresses etc etc. How do I create a formula that wil result in having each persons *first name, initial of middle name surname and email address * ? I would really appreciate some help. Thank you. Ka -- Kat Hughe ----------------------------------------------------------------------- Kat Hughes's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1674 View this thread: http://www.excelforum.com/showthread.php?threadid=31952 You didn't bother to tell us your setup so try thi...

How to setup formula to collect ongoing information
I have setup a questionnaire which will continuously have an answer section added to it. I am setting up a formula to count the yes and no answers. How would I set a formula up to count all the ongoing answers? Example would be =COUNTA(B6:G6) but then I add another two column of answers and need the formula to now read =COUNTA (B6:I6). Do I need to keep adding a new formula? Thank you. Hi, easiest way is using 'dynamic ranges' (http://www.contextures.com/xlNames01.html#Dynamic) HTH -- Pecoflyer Cheers -------------------------------------------------------------------...

Combo Box #8
I am trying to duplicate what another person did for consistency but can't figure it out. A Combo Box appears with the black upside-down triangle at the right side of the object. This triangle appears on a printed page just as it appears onscreen. There is another option for a "drop-down box", however, that I can not figure out how to duplicate. A cell appears to just have numbers or text in it, but when the cell is selected the black triangle appears, giving options to select. I can not figure out how to create this in other cells, or even edit the referenced cells which pr...

h:mm:ss formula
How would you calculate the total times if your times were entered as: Example Column C:C will have 5 for 5 minutes, .30 for 30 seconds, 15 for 15 minutes. And so on... I can't seem to figure out how to tell excel that a decimal number is seconds and a whole number is minutes. Up to 59 minutes, then my sum total time would be h:mm:ss. Thanks so much for your help!!! On Sun, 10 Apr 2011 18:27:59 -0700 (PDT), Dick <bobdelrn@yahoo.com> wrote: >How would you calculate the total times if your times were entered as: >Example >Column C:C will have 5 for 5 minutes, .30 for 30 seco...

=?Utf-8?B?5oCl77yB5oCl77yB5oCl77yB5oCl77yB5oCl77yB5oCl77yB?=
您好� 我的一个非常重要的EXCEL文件,有近10M大!非常重要!可是总是出现这样的问题:一会儿能打开;一会儿又不能打开,同时它会弹出一个Dr.Watson的应用程序出错的窗口说:“意外错误:访问冲突(0xc0000005),地址:0x30301d24”,然后它将关掉EXCEL这个软件!天啦我同时打开的EXCEL文件还未保存,你说我多惨啊!那位大侠快行行好吧!我的EMAIL:ZYS_LUCKY@163.COM,有消息快答复我!不胜感激!!!! ...

Booleans in Array formulas
eg N N O O D D D O and I want to extract those that are NOT "O" or "D" ={NOT(A1:A8="D")} works ={NOT (A1:A8="O")} works but i can put them together ={(A1:A8="D") + (A1:A8="O"))} gives me an array filled with #value ive also tried ={AND (A1:A8="D"),(A1:A8="O")} and as many combination s as you can think of and cant get it. Can it be done ? One way (array-entered): =NOT((A1:A8="D")+(A1:A8="O")) In article <e742a0ce.0404230818.740b2c0d@posting.google.com>, pdc124@yahoo.co.uk (p co...

copying formulas #3
I copied the following formula to another cell: =INDEX(LumberDB,MATCH('Lumber Gabel Roof'!B6,LumberSize,0),MATCH('Lumber Gabel Roof'!B18,BoardLength,0)) In the cell I copied the formula to I changed the first Match to cell B7, and the second Match to cell B8. The copied formula with changes results in #NA. B7 and B8 cells are formatted like the cells in the copied formula. =INDEX(LumberDB,MATCH('Lumber Gabel Roof'!B7,LumberSize,0),MATCH('Lumber Gabel Roof'!B8,BoardLength,0)) What's going on? Help is appreciated. Are the values you're referring t...

a repeating formula based on multiple options
I am struggling to come up with an elegant formula solution to accomplish the following task... I have a schedule with people working 21-7 (21 days on and 7 days off) and 10-4 (10 days on and 4 days off)schedules. By defining either of these schedule options in one column and the day number of their rotation (say, the schedule is starting on day number 3 of a 10 day rotation) I want to create a formula to complete the rows of a schedule to show "working" or "off" based on just these two variables. If A1 is "21-7" (or "10-4") and B1 is <=...

Named formula for integration
I have a tool for integrating and differentiating functions using Excel, see http://www.engineersexcel.com/Tools/Function%20Calculus/Description.htm I have 2 questions: 1. Can a named formula be used for integration ? That is, if a named range, say X(n) has n numbers in it, can there be a named formula Y(n) that works as follows: Y(1) = X(1) Y(n) = Y(n-1) + X(n) for all n > 1 ? 2. Is there a way a data table can be stored as a named range ? (If the above are possible, then it will be possible to rewrite the tool without any calculations on the spreadsheet itself.) Any comments would ...

CRM 3.0 and IE 8 causing Outlook client to prompt for network id/p
We use CRM 3.0's Outlook Client. We recently upgraded to IE 8. Ever since then, the users have been getting prompted for their network id/pwd when accessing CRM through Outlook. If they hit Cancel a few times, the page loads. The site is in Trusted Sites both as the IP and server name. They can access CRM through the web app with no log in prompts. Is this a bug or just a configuration issue? Thanks! make sure the Logon Settings is "Auto logon with current username and password" for Trusted Sites. If the problem still occurs, then you need to delete Temporary Inter...

Excel 2000
Hi Guys, This one should be simple for you guys! In Excel 2000, I have cells that are protected (Locked and Hidden). When I protect the sheet I use the UserInterfaceOnly option of the protect function. However I could not access the cell.formula even by code when the sheet is protected. Is this a normal behavior? And if so, Is there any workaround other than unprotected the sheet? Thanks, Lionel If you want to view the formula but protect the cell, do not check the "Hidden" checkbox when formatting the cell for protection. Be sure the "Locked" ch...

vlookup formula
Is it possible to use a cell refence, in which the referred to cell lists the workbook and array, as the range for a lookup formula. I am attempting to use the same VLOOKUP formula to access a variety of files which are employee timesheets. I am using a CONCATENATE to build the correct file name for a given timeperiod and employee placed in CELL A1 - now I would like to insert this filename in the Range portion of the lookup file by telling the formula to look in cell A1 for the filename, but cannot seem to find a way to do this, the formula wants to find a file with the name A1. any idea...

Combine text and formula
Please could someone help me with the following :- I'm trying to create the following string which automatically update itself Report Date 6th June 2004 I seem to be struggling with the syntax to achieve this. ='Report Date'&today() doesn't work ?? Thanks TWACCES -- Message posted from http://www.ExcelForum.com One way ="Report Date "&TEXT(today(),"mm/dd/yy") -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom "twaccess >" <<twaccess.17d5f4@excelforum-nospam.com> wrote in m...

Need help writing a workable formula in form design......
I'm trying to write a workable formula in an unbound text in form design. It's a monster formula. Their are 4 components: comp/att*100-30/20 yds/att-3*.25 td/att*20 2.375-int/att*25 Each one of the answers for these 4 components must be checked , if greater than 2.375 then set to 2.375 and if less than 0 then set to 0 and finally, all added together, multiplied by 100 and divided by 6 This is what I have but I get Syntax Error. I'm very new to access, so please keep this in mind, thank you. =PasserRating:([comp]/[Att]*100-30/20+iif(>2.375=2.375),iif(<0=0)+[yds]/[att]...

Business Portal in Version 8.0
Hello, has anyone implemented the ebusiness portal to collect timesheeting data in verson 8.0 of GP? Dan, Thanks for using the Newsgroup. PS time and Expense is now included with Business Portal 2.5. This is an addon module that can be purchased for Business portal. More information on this is available on partnersource/customersource. Thanks and let me know if you have anymore questions. Jake MBS Senior Support Specialist "dan" wrote: > Hello, has anyone implemented the ebusiness portal to collect timesheeting > data in verson 8.0 of GP? > ...