I'm needing a formula that will do the following... If cell A1 is 1 it shows with the word Developing. If A1 is 2 it shows with the word Performing. If A1 is 3 it shows with the word Leading. Thanks

0 |

5/17/2010 9:52:01 PM

you could put this formula in b1 =CHOOSE(A1,"Developing","Performing","Leading") -- Gary Keramidas Excel 2003 "Redroc" <Redroc@discussions.microsoft.com> wrote in message news:7C464B73-6438-4BD7-8002-DC494926E073@microsoft.com... > I'm needing a formula that will do the following... > > If cell A1 is 1 it shows with the word Developing. If A1 is 2 it shows > with > the word Performing. If A1 is 3 it shows with the word Leading. > > Thanks

0 |

5/17/2010 9:57:16 PM

Look in the help index for IF -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett@gmail.com "Redroc" <Redroc@discussions.microsoft.com> wrote in message news:7C464B73-6438-4BD7-8002-DC494926E073@microsoft.com... > I'm needing a formula that will do the following... > > If cell A1 is 1 it shows with the word Developing. If A1 is 2 it shows > with > the word Performing. If A1 is 3 it shows with the word Leading. > > Thanks

0 |

5/17/2010 9:58:09 PM

=IF(A1=1,"DEVELOPING",IF(A1=2,"PERFORMING",IF(A1=3,"LEADING",""))) -- Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Redroc" <Redroc@discussions.microsoft.com> wrote in message news:7C464B73-6438-4BD7-8002-DC494926E073@microsoft.com... > I'm needing a formula that will do the following... > > If cell A1 is 1 it shows with the word Developing. If A1 is 2 it shows > with > the word Performing. If A1 is 3 it shows with the word Leading. > > Thanks

0 |

5/18/2010 2:00:42 AM

When I reply to an email, my signature superimposes over the sender's message. What am I doing wrong? ...

Hi, When you click in a cell with a formula, Excel will then put color around the cells that are referenced. Somehow I turned that feature off. Now I do not get colors in th other cells. Where is that option to turn it back on???? I've looke and looked but I just can't find that option. Thanks for the help -- albea ----------------------------------------------------------------------- albean's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2875 View this thread: http://www.excelforum.com/showthread.php?threadid=48436 ...

hiiiiiiiiiiiiii ...

I'm working on a monthly budget/check registry spreadsheet. What I want to do is have the check register link to the allowed balances in the monthly budget. I have two fields in my monthly budget for each item. A projected cost and actual cost. I want to link entries in the check registry to the actual cost of the fields in the monthly budget. I plan to use account numbers to link these fields to each other. For example . . . Say I buy groceries for $50. When I enter this into the check registry I enter all the necessary information along with an account number that links this tra...

B of A (Washington) using Yodlee & msn to sync data. The problem I'm experiencing is that the Payee field is being cut off. I've used /using the Payee Rules Manager, which has been working to a certain extent. My question is... What is the size limit for the payee field? A typical transaction from bofa(WA) looks like "PURCHASE 5xx29xxx658xxxxx3 ON 12/30 AT CASTLE ICE RENTON WA" When synced as configured above all i get is a very small portion, maybe part of the actual name. Second question is when trying to do a manual export from bofa (Wa) website I have the opt...

I need to make a formula for alook up. The first spreadsheet i inventory, the second one is pg 103 strapping. I want to enter the fee and inches for pg 103 on the inventory and have it look up the feet an inches on strapping chart and enter the appropriate gallons in column Attachment filename: p & g 101 strapping.zip Download attachment: http://www.excelforum.com/attachment.php?postid=50210 -- Message posted from http://www.ExcelForum.com ...

I would like to know the formula to work out my employees employment duration, from a given start date to the current day. many thanks Take a look at DATEDIF. Explained at http://www.cpearson.com/excel/datedif.htm -- HTH RP (remove nothere from the email address if mailing direct) "Ska" <Ska@discussions.microsoft.com> wrote in message news:B10818AE-1CAD-4CE5-BDED-BC0DDC96C876@microsoft.com... > I would like to know the formula to work out my employees employment > duration, from a given start date to the current day. > > many thanks Thanks Bob, I have us...

Hello! Can somone help me with this formula 2004:21-0-1-1-11 in this cell i wan't to get out "21" 2005:2-0-0-0-1 in this cell i wan't to get out "2" My result from the formula is "-21" and ":2-" is there a formula that i can use on both and get the result "21" and "2"? I want to add the together at the end and get the result "23" but with : and - i only get error. -- johhny ------------------------------------------------------------------------ johhny's Profile: http://www.excelforum.com/member.php?act...

How do I convert column of numbers (n=3000) to log 10 column of numbers? Assuming that your column is column A, one way: In an unused column, enter =LOG(A1) and copy down 3000 cells. Copy the column, choose column A and choose Edit/Paste Special, selecting the Values radio button. In article <0CDE6301-FC9C-488C-9D9F-3AD26B46EFCE@microsoft.com>, "Fishfan" <Fishfan@discussions.microsoft.com> wrote: > How do I convert column of numbers (n=3000) to log 10 column of numbers? ...

Hi, I am wanting to concatenate a set of text to create a formula. I have done so below. =CONCATENATE("=MAX('",O1,"'!A3:A65536)") The result is: =MAX('2009'!A3:A65536) ....but it treats this as a text string when I try to use INDIRECT Cell O1 contains the year minus 1. In this case O1 = 2009. All of my worksheets are named as a year e.g. 2007....2008....2009...2010. I am entering this on sheet 2010. Now the real question: How do I make another cell evaluate this string as an actual formula and spit out the highest number for ...

Help!!! Is there a way to have a formula where a cell with text is in it, but it is not included in the formula. Like I have a random cell that appears sometimes within the range but because it is text and I do not want to include it in the formula. Is there a certain "symbol" that could be used? HELP!! Hi maureen, It depends on what the actual formula is, but *some* functions ignore text entries. You could use the ISNUMBER function to include only those entries that are numbers. Post your formula for a more detailed reply. Biff >-----Original Message----- >Help...

I'm trying to have a formula do 3 scenerios in one cell and have a partial formula working: IF(AND(G39>30, G39<=7),3000) which equates to if cell G39 is greater than 0 and less than or equal to 7 use 3000. I would like to continue the formula that if G39 is greater than 7 and less than 14 use 5000 and if G39 is greater than 14 use 7500. How can I do this? Hi, =IF(AND(G39>0, G39<=7),3000,IF(AND(G39>7, G39<=14),5000,if(G39>14,7500))) "tom" wrote: > I'm trying to have a formula do 3 scenerios in one cell and have a partial > form...

I need help with a formula. I can't figure out how to calculate for missing number. '05 we sold x units, I know we had a X% increase over '04 so what wa the '04 sales? Column A = '05 Columb B = '04 Column C = % increas -- bab ----------------------------------------------------------------------- babz's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2781 View this thread: http://www.excelforum.com/showthread.php?threadid=49307 '04 sales = '05 sales / 1.X% increase Vaya con Dios, Chuck, CABGx3 "babz" wrote: >...

There is no way for me to run a report on Buydown Pricing, is there anyone who has a report for this option? If not, can someone write a custom report for it, and how much might something like this run me? I would like it to do something like buydown quantity greater/less/equal and same for buydown price... please contact me at nagarra @ yahoo . com or respond here with your contact info! -- Thank You Vince :) ...

I'm running Vista Home Premium, SP2, 2 GB of RAM, Firefox, WLM, all WU's current. I was in WLM mail newsgroups earlier today and things just stopped. WLM stopped responding. Now I cannot log into WLM. It used to log into window Live by itself (password and all) from my desktop icon, but now the only thing that happens when I try to open my WLM app window is I'm taken to IE (7). Then when when I try to sign in Windows live it won't do it. I've already ran SAS, MBAM, CCleaner and Avira in Safe mode but found nothing. Then I did a system restore back to a fe...

Can anyone please help me, I am trying to copy a formula =(sump1:p3) from one worksheet into a new worksheet. When I go to paste the formula the only thing that comes up is =SUM(#REF!). Can I even copy and paste a formula from one worksheet into a new worksheet? and if so how? Thanks When you paste a formula it relatively changes the cell references to suit where you have pasted it to. EG. If you pasted =sum(P1:P3) from cell P4 to cell B4 it would change to =sum(B1:B3). However, if you pasted it to cell B2 it could not reasonably change the references. If you are pasting because you...

give me complete formula See http://www.xldynamic.com/source/xld.xlFAQ0004.html -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Naveed" <Naveed@discussions.microsoft.com> wrote in message news:29B7C0D6-1DED-4321-B1EB-CA6DDCE73852@microsoft.com... > give me complete formula > ...

The smtp outgoing email with VISTA cannot be authenicated. Vista is not an e-mail client. Please post the error message in its entirety. You can left click on it to highlight and then right click to copy and then paste it into this thread. -- Bruce Hagen MS-MVP [Mail] Imperial Beach, CA "Charles" <Charles@discussions.microsoft.com> wrote in message news:62A2017F-A531-4E34-89CC-7FE3BD9849F0@microsoft.com... > The smtp outgoing email with VISTA cannot be authenicated. ...

I had wanted to set up a separate identify to get my work e-mail as Windows Mail, rather than the webmail from my ISP; didn't know until after completing the process that Windows Mail combined both personal and work e-mail into one account. If I "undo" it, popup says I'll lose all of my work e-mail. How can I save it and undo the dual identities? -- mikezot Undo what? Windows Mail doesn't have identities. (boilerplate reply) You can add multiple accounts, via Tools - Accounts - Add, but Windows Mail doesn't have identities or a password option.......

In order to simplify the maintenance of workbook formulas I need to reference workbook name in hyperlink formula =[myWorkbok.xls]mySheet!$E4 in this way =[A1]mySheet!$E4 given the file name stored in cell A1 Cell A1 : myWorkbook How do I write the formula to make it work? Will it work even if the referenced workbook is closed? Regards Frank Krogh The function you'd want to use is =indirect(). But =indirect() won't work if the sending file is closed. Laurent Longre has an addin (morefunc.xll) at: http://xcell05.free.fr/ or http://xcell05.free.fr/morefunc/english/index.htm ...

I need to create a single formula for my workbook that references cells from various tabs (over 20) in another workbook. I want to copy this formula into multiple tabs within my workbook. My workbook and the external workbook have the same number of and identically named tabs. I want to embed a variable into the formula that will take on the name of the tab that the formula is copied to. I imagine the formula would look something like this: ='K:\Sales Reports\[Ohio Team, Mar-21-2004.xls]variable_identifying_the_tab_goes_here'!D1 I know I can use the following formula to derive th...

Hi All, It has been over 10 years since I did my Excel studies and I've unfortunately forgotten everything I haven't used regularly. My office has recently upgraded to Office 2007 (upgrade not being the descriptor I'd have chosen!) and I'm struggling with Excel. I've found my way around most issues, but I'm REALLY stuck now and suffering Friday-itis on top of it all! Essentially I have a multi-sheet workbook for my debtors ledger. Each page has separate columns for the customer numbers, names, total debts in each age range (7 days, 14 days etc), totals and lastl...

After GP 10 upgrade, I am getting the login failed error for all useers who tried on working on my customized Dynamics VBA project. Error # -2147217843: Login failed for user 'sa'. Procedure: frmDateEntry - cmdProcess_Click Source: Microsoft OLE DB Provider for SQL Server Thanks for help. Kevin Kevin, You might need to re look at your connection in VBA -- Thanks Janakiram M.P. MCP-GP http://janakirammp.blogspot.com "Kevin Zhou" wrote: > After GP 10 upgrade, I am getting the login failed error for all useers who > tried on working on my customized Dynamic...

I want to add a field "Company" to my contact information. I have entered a new field called "Company" in the attributes of the schema "Contacts" and it is listed there as "CFSCompany" as a string. I then went to customization in crm settings and edited the "Contact" fields by removing "Middle Name" and adding "Company". I then save this new layout. However when I go to "New Contact" the "Company" field is not there and "Middle Name" is still there. What step am I missing to publish this...

here's my question... i have a cell that has a text field of this type: '9-19' (a-b) I want to create a formula that will subtract 19-9 (b-a) and return the result as a number// can anyone help?! is this even doable? I'd really appreciate it! PS also, i'm very fairly new at excel so a detailed response with th formula would really help! ALe ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com Try: =MID(A1,FIND("-",A1)+1,99)-LEFT(A1,FIND("...