Help With Formula #5

I have data in a worksheet 
   A         B     C
1 Verify      2%    99%
2 Audit       2%    98% 
3 Account     5%    97%
4 Forward     4%    96%
5 Place       5%    95%

I have another cell (F1) in the sheet that i would like to 
list the text in A1, but only if B1 is at least 5% if not 
then I want it to list A2, but only if B2 is at least 5% 
and so on down to A5. Please Help.  
0
anonymous (74722)
1/8/2004 9:25:21 PM
excel.misc 78881 articles. 5 followers. Follow

4 Replies
267 Views

Similar Articles

[PageSpeed] 2

What happens with row 3 and row 5?

-- 
Don Guillett
SalesAid Software
donaldb@281.com
"Report Lackey" <anonymous@discussions.microsoft.com> wrote in message
news:033b01c3d62d$ebd800e0$a401280a@phx.gbl...
> I have data in a worksheet
>    A         B     C
> 1 Verify      2%    99%
> 2 Audit       2%    98%
> 3 Account     5%    97%
> 4 Forward     4%    96%
> 5 Place       5%    95%
>
> I have another cell (F1) in the sheet that i would like to
> list the text in A1, but only if B1 is at least 5% if not
> then I want it to list A2, but only if B2 is at least 5%
> and so on down to A5. Please Help.


0
Don
1/8/2004 9:37:52 PM
One way is as follows
=IF(B1>=5%,A1,"") and copy down the rows.
Rob

"Report Lackey" <anonymous@discussions.microsoft.com> wrote in message
news:033b01c3d62d$ebd800e0$a401280a@phx.gbl...
> I have data in a worksheet
>    A         B     C
> 1 Verify      2%    99%
> 2 Audit       2%    98%
> 3 Account     5%    97%
> 4 Forward     4%    96%
> 5 Place       5%    95%
>
> I have another cell (F1) in the sheet that i would like to
> list the text in A1, but only if B1 is at least 5% if not
> then I want it to list A2, but only if B2 is at least 5%
> and so on down to A5. Please Help.


0
robnobel1 (59)
1/8/2004 9:38:04 PM
Just noticed that you only wanted the result to appear in F1.  I don't think
that's possible as if more than 1 item is 5% or more than you're going to
have a conflict.
Rob

"rob nobel" <robnobel@nospamdodo.nospamcom.nospamau> wrote in message
news:Oegib#i1DHA.4032@tk2msftngp13.phx.gbl...
> One way is as follows
> =IF(B1>=5%,A1,"") and copy down the rows.
> Rob
>
> "Report Lackey" <anonymous@discussions.microsoft.com> wrote in message
> news:033b01c3d62d$ebd800e0$a401280a@phx.gbl...
> > I have data in a worksheet
> >    A         B     C
> > 1 Verify      2%    99%
> > 2 Audit       2%    98%
> > 3 Account     5%    97%
> > 4 Forward     4%    96%
> > 5 Place       5%    95%
> >
> > I have another cell (F1) in the sheet that i would like to
> > list the text in A1, but only if B1 is at least 5% if not
> > then I want it to list A2, but only if B2 is at least 5%
> > and so on down to A5. Please Help.
>
>


0
robnobel1 (59)
1/8/2004 9:43:13 PM
It's a bit clumsy, and I am sure there is a more elegant solution, but this
works:

=OFFSET(A1,SMALL(IF(B1:B6>=0.05,ROW(B1:B6)),1)-1,0)
array entered with Ctrl-Shift-Enter

It produces an error if nothing in B is over 5%

Tim C

"Report Lackey" <anonymous@discussions.microsoft.com> wrote in message
news:033b01c3d62d$ebd800e0$a401280a@phx.gbl...
> I have data in a worksheet
>    A         B     C
> 1 Verify      2%    99%
> 2 Audit       2%    98%
> 3 Account     5%    97%
> 4 Forward     4%    96%
> 5 Place       5%    95%
>
> I have another cell (F1) in the sheet that i would like to
> list the text in A1, but only if B1 is at least 5% if not
> then I want it to list A2, but only if B2 is at least 5%
> and so on down to A5. Please Help.


0
timclainc (28)
1/8/2004 10:38:17 PM
Reply:

Similar Artilces:

Writing formula for excel worksheet
Item Rate1 Rate2 Rate3 A 3 4 6 B 8 5 23 C 56 5 78 Above is my excel sheet. I want to write some formula so that in every row cell having minimum rate should come bold. Like For Item A - Rate1(3) for Item B - Rate2(5) For Item C - Rate2 (5) There may be a neater way but this works. Somewhere in you sheet in a cell type =min(A1:a4), I used L1 Change this to watever range you are trying to evaluate. Then select this range and click format - conditional format - cell value - is equal to =($L$1) and apply your bold font. The lowest value in the range will then become bold. Mike "Gaur...

Hotmail Problem Please Help
I am running Exchange 2003 Standard on a Windows 2003 Server. I also have ISA 2000 on the same box. Everything is working fine. The problem I am having is getting mail out to a hotmail address. When I send then mail, I see it sits in the Queue for less then a minute then disappears. It never makes it to the Hotmail address nor do I get any return errors back in my client indicating the mail never made it to its destination. On Sun, 13 Nov 2005 15:51:04 -0800, "Kevin Mc" <Kevin Mc@discussions.microsoft.com> wrote: >I am running Exchange 2003 Standard on a Windows 200...

help for sql select command !!!
Hi Everyone! Imagine we have 3 checkBoxes in a search page and 3 boolean fields in DB table and every checkbox is for one of these fields . In search page users check every 3 checkBoxes and what i want is that first it shows the records that every their 3 fields are checked then 2 and then 1(DESC). BTW my DB is MS Access. Please help me ! On Mar 1, 7:17=A0pm, "miladha...@gmail.com" <miladha...@gmail.com> wrote: > Hi Everyone! > Imagine we have 3 checkBoxes in a search page and 3 boolean fields in > DB table and every checkbox is for one of these fields . I...

Error in Exchange 5.5 Public Folder access via Outlook 2000
Hi We're running Exchange 5.5 SP4 on NT4, with the May 2004 rollup (841765 - Store.exe and Mdbmsg.dll = 5.5.2658.4) Outlook 2003 clients can access a shared Public Folders contacts list fine through the Address Book application, but Outlook 2000 users can't. Both groups can see and manipulate the actual folder OK, it's just the Address Book that's not working (either through the Address Book icon, or through creating a new mail and clicking on the "To" button and selecting the folder from there). Outlook 2000 users see a blank list, with the slider on the right siz...

Exchange 5.5 to 2003 Migration Question #3
Hello, We are currently migrating users to Exchange 2003 from 5.5. The 5.5 server is located here and the new 2003 server is located in a different office. One user (who we have moved already) is trying to access and user's calendar, but that user is still on 5.5. They are getting the following error: unable to display the folder. The information store could not be opened Any ideas on how to make the user on 2003 (running Outlook 2003) connect to the user's calendar on the 5.5 server? The user has the "Owner" permission on the 5.5 calendar. Thanks! ...

moving exchange 5.5 server to a different domain
I have an exchange 5.5 site with 3 servers in it. They are NT 4.0 and Exchange 5.5 They are all in domain a. There is a two way trust with domain a and domain b. I need to move one of the servers from domain a to domain b. Since I have permissions via the trust to the exchange services site acct. , is this as easy as removing the server from domain a and adding it to domain b, then bringing exchange services back up? Or is there a set procedure that should be followed? "=?Utf-8?B?Y2dsYWR5MjAwMA==?=" <cglady2000@discussions.microsoft.com> wrote in news:1A7E7702-914A-...

RETAIL MARK UP FORMULA
does excel have retail mark up formula built in? No. You just use the formula. Selling = Cost * (1 + Markup%) -- Regards, Fred Please reply to newsgroup, not e-mail "jimbo" <jimbo@discussions.microsoft.com> wrote in message news:F862FB6B-C25F-483F-A480-F3F7C9971068@microsoft.com... > does excel have retail mark up formula built in? ...

Excel example-formula C4+C5 adds before data in C5 Can I get it t.
I'm trying to create a formula (for example): In cell D5 I want it to add C4+C5. I would like it to work only after there is data in C5, but not before. How can I get it to work only when there is data in C4 & C5? Right now its showing what I have in C4. =if(count(c4:c5)<2,"Not enough values!",c4+c5) New Excel User wrote: > > I'm trying to create a formula (for example): > In cell D5 I want it to add C4+C5. I would like it to work only after there > is data in C5, but not before. How can I get it to work only when there is > data in C4 & C5? R...

More Formula Help
Hi again, I am trying to reconfigure my formula so that if A2 is EXACTLY equal to any cell in the range B2 to B5, display a 1 in cell C2, else display a 0 in cell C2. Am I close with these formulas??? =SUM(EXACT(A2,"*"&$B$2:$B$5&"*"),1,0) =IF(EXACT(A2,"*"&$B$2:$B$5&"*"),1,0) ...

What is the formula payment for $48,800 for 30 years at 8% Interes
Please some give me the formular 48,400 8 % 30 years =SUM(48,800*8/12) ??? The payment is 358.08 but how can figure it I need the correct formula to get the monthly payment? I have a computer class THIS IS URGENT!!!!!!!!!!!!!!!!!! "Help I need the answer asap!!!" <Help I need the answer asap!!!@discussions.microsoft.com> wrote: > THIS IS URGENT!!!!!!!!!!!!!!!!!! You are more likely to get the answer you need quickly if you take the time to form your question clearly and without typos. > 48,400 > 8 % > 30 years > =SUM(48,800*8/12) ??? > The pa...

I need help on this ....
Production data Sheet _______________ Job no time 1001 60 1001 50 1001 40 1002 30 1003 50 1003 30 1004 10 Price data Sheet ____________ Job no Price 1001-1003 100 1004 200 1005-1007 500 Merge Data (This is what i wanted) ______________________________ Job no time Price 1001 60 $23.08 1001 50 $19.23 1001 40 $15.38 1002 30 $11.54 1003 50 $19.23 1003 30 $11.54 1004 10 I have 5k rows of data. How can i merge production data and price data together based on the job No Where does 23.08 etc. come from? -- --- HTH Bob (there's no email, no snail mail, but somewhere should b...

newbie trouble with formula
Hi all..could you please help me with the following formula? =if(weekday(B2-1)=1,B2-3,B2-1) B2 is 7/31/2008. I'm very new at excel, please forgive my lack of knowledge. Thanks! -- jenn k There's nothing wrong with your formula so you'll need to explain the logic of what you want to do. Here's what your formula is saying: If B2-1 = Sunday, subtract 3 days from B2 otherwise subtract 1 day from B2. Is that what you want it to do? -- Biff Microsoft Excel MVP "jenn k" <jennk@discussions.microsoft.com> wrote in message news:BE60D6AD-D058-4631-BC33-3522EF...

Breaking Formulas using Pivot Table
I have Tab1 that has data in it in the form of a pivot table. I then have another sheet, Tab2, that pulls data from Tab1. This all works, but when I try to copy Tab2 into a new workbook (so that I can e-mail only that tab) a bunch of my formulas in Tab2 fail. If I refresh the pivot tables they work again or if I do a Replace "=" with "=" it seems to trick it into working (but some percent formatting changes to dollar formatting for some reason). I just want to know if there is an easy way to make the new workbook without breaking the formulas in my old one. Thanks in adv...

Showing #N/A in a formula
I�m using VLook Up and I don�t want to show the result when it is equal to #N/A, or change it by another value. I can do it replacing formulas by values, but I wouldn�t like to do this. Any ideas? Thanks a lot!!!! --- Message posted from http://www.ExcelForum.com/ Select all the culprit cells and use conditional formatting: change "cell value is" to "formula Is" and, assuming E1 is the active cell, enter: =ISERROR(E1), then click the format button, Font tab, make the font white. Bob Umlas Excel MVP "Nekro >" <<Nekro.152xn4@excelforum-nospam.com&g...

Cannot access a file -- HELP
I have this problem at work (using Excel 2000 Windows 2000) and at home (Excel 2003, Windows XP Pro). SOMETIMES...not always, I try to access a file on a network drive I get the message: "path..filename could not be found. Check the spelling of the file name and verify that the file location is correct". Once I get the message on that file, I always get it on the file....but there might be 27 others in the same folder that I can open. And I get the message if I try to open the file via explorer or via Excel. If I copy the file to my C: drive it opens fine. I even tried t...

#VALUE! On An Array Formula Referencing a Range Outside The Workbo
This formula works only when i have the other referenced workbook open simultaneously...when it is not open, i get the #VALUE! error.... Array Formula: {=SUM(IF($F$5:$F$92=$F280,O$5:O$92))+SUMIF('O:\Gruss Value Fund\Capital\2005\[GV LP Capital 2005.XLS]SUMMARY'!$G$1:$G$95,$F280,'O:\Gruss Value Fund\Capital\2005\[GV LP Capital 2005.XLS]SUMMARY'!M:M)} There are some functions that don't work with closed workbooks. You found one with =sumif(). But you could use a different formula to replace the =sumif() portion: =sumproduct(--('yourpath\[GV LP Capital 2005.XLS]SU...

Help GroupWise Plugin for Outlook
Anyone know if Outlook 2003 can be used as a client for GroupWise? There used to be a plug in module for older version of outlook. I know that OL can POP mail from GW, but my company has POP disabled. Any advice appreciated. -- Dab Cut off: yourhead to respond ...

Formula for adding time 02-25-10
Hello, I want to put in a start time in B2 and have B3, B4, B5, B6 be filled in with a formula. If I put 1:00 pm in B2 - B3 would add to 1:40 and so on. A B 1 Location start time 2 stop 1 3 stop 2 B2 + 40 minutes 4 stop 3 B3 + 55 minutes 5 stop 4 B4 + 35 minutes 6 stop 5 B4 + 75 minutes 7 8 How long 9 25 minutes 10 30 minutes 11 45 minutes 12 50 minutes 13 75 minutes Thank you, Doug Doug, select a cell to t...

Incorrect formula #2
Hi, I have the following but have made mistakes in the formula. =IF(OR($P$53>499,L34="D",L34="P"),P34*10%,IF(OR($P$53>499,L34="D",L34="Pre",N34="Y"),P34*5%,)*NOT($R$35="NT")*NOT($R$36="NP")) What I want to achieve is this. In Cell where formula is. will be nothing, or 10% or 5%. If a "N" is in Cell N34 and P53>499, or L53 contains a "D" or "P" then the result is 10% but if a "Y" in Cell N34 then 5%, if neither a N or Y then result is nothing. Again if R35 is "NT&qu...

New to Exchange Server. Help!
Exchange Server 2003. Dear group: I have installed Exchange Server on my new Windows 2003 Server. Now what? I have no documentation (none came with the Small Business Server 2003 Premium CDs that I could find). I need an administrator's guide with setup instructions. Let me vent somewhat . . . Why does Microsoft sell these products to small nonprofits like us and expect us to use them without some documentation? If I have missed something, please let me know. I will gladly eat crow. God bless and thanks for any help. -- Dr. Doug Pruiett Good News Jail & Prison Ministry...

End Of Month Formula
Good evening all. I am a little stumped here, cannot seem to resolve this simple requirement. In cell A1 I have the value from 1 to 12 (representing the month). (This is manually entered.) Now, in cell B1, I would like to enter a formula, so that the last date of the month in A1 is shown, eg A B 1 5 30/05/03 .... or A B 1 12 31/12/03 ... etc As usual any assistance would be grayefully received. Cheers, Mathew --- Outgoing mail is certified Virus Free. Checked by AVG ant...

Circular reference help
Hello, does anyone know whether it is possible to stop Excel 2007 from firing up Help whenever it gets a circular reference, please? I have some spreadsheets which, after updating data-links, form circular references. This is easily corrected by moving some totals in line with the updated data. I don't disagree with Excel prompting me that the circular references exist but I do not want it to fire up the help system. I know the issue and I am just about to fix it, the only thing delaying me is the Help window getting in the way. Regards Chris easiest way is Office button/Excel Optio...

FOrmula Help Please, Im so confused
I have a formula that outs out net margin which is =(Margins!$C$6-MIN-'TMobile 18 Costs'!D5) I also have another formaula that turns negative into positive If a positive states "FOC" if negative adds VAT and rounds up to nearest 9.99. =IF(C8>=0,"FOC",CEILING(-C8*1.175,10)-0.01) So if a neative was -89 turns it into +89 *1.175 = 105 then changes it to 109.99 automatically With me so far. So what i need is a formula that does all that in one formula so i dont have to create double columns ot work it out!!!!!! Either =Margins!$C$6-MIN-IF('TMobile 18 Cos...

Formula
Does anyone know any easy way to calculate the value of an investment where you put for example, $1000 per week into an account that has 6% interest for 12 months. Also, similar scenario where you put $4000 per month into an account @ 6% interest. How do you calculate it's value after 12 months. Thanks On Jul 7, 11:49 pm, "JoeBloe" <leavemeal...@hotmail.com> wrote: > Does anyone know any easy way to calculate the value of an investment where > you put for example, $1000 per week into an account that has 6% interest for > 12 months. Also, similar scenario wh...

Dlookup Help 02-04-08
I am using the following DLOOKUP string. =DLookUp("TXTFIELD","Query3","Query3.CustomerNumber=" & "[CustomerNumberFromReport]") I am try to use the Dlookup to use a value that I get in the report to lookup in a query and return me back some text. The problem that I am encountering is it is selecting the first record in the query and not based on the customer number. Hi - How are you using this expression? Is it a report Controlsource? If so, what section of the report is it in, and what section of the report is [CustomerNumberFromReport] in? ...