How does Niek's URL differ from yours? http://www.uwgb.edu/dutchs/UsefulData/UTMFormulas.HTM ..Niek's post http://www.uwgb.edu/dutchs/UsefulData/UTMFormulas.HTM .JP's post Gord Dibben MS Excel MVP On Mon, 21 Jan 2008 10:39:58 -0800 (PST), JP <jp2112@earthlink.net> wrote: >How about this? > >http://www.uwgb.edu/dutchs/UsefulData/UTMFormulas.HTM > >HTH, >JP > > >On Jan 21, 1:14�pm, TechnoGram <mumz...@hotmail.com> wrote: >> need formula to change a gps settings in spreadsheet from UTM to >> longtitude and latitude.... � �Any ideas?

0 |

1/21/2008 7:21:33 PM

I see.........the LOL in your one post was in reference to you both posting the same URL. Now, I get it<g> Gord On Mon, 21 Jan 2008 14:01:34 -0800 (PST), JP <jp2112@earthlink.net> wrote: >It doesn't. FYI his post hadn't appeared when I started composing my >reply. > >Thx, >JP > > >On Jan 21, 2:21�pm, Gord Dibben <gorddibbATshawDOTca> wrote: >> How does Niek's URL differ from yours? >> >> http://www.uwgb.edu/dutchs/UsefulData/UTMFormulas.HTM� ..Niek's post >> >> http://www.uwgb.edu/dutchs/UsefulData/UTMFormulas.HTM� .JP's post >> >> Gord Dibben �MS Excel MVP >> >>

0 |

1/21/2008 11:06:58 PM

I am trying to get excel to stop automatically editing my formulas when I delete cells. Like right now I have a two lists of data and I'm going through to find the same data points between the lists. So I have on list in column B and one in column C. So my formula in column D is =if(B1=C1, "TRUE") but every time I go to delete cells from column C and move them to the top my formula changes to =if(B1=!REF, "True") and if I deleted say one cell the next line row in column D the formula will be =if(B2=C1, "TRUE") How Can I stop Excel from doing this? Wra...

What is the formula that will add the content of a cell on one worksheet (sheet 1) to the contents of another worksheet (sheet 2)? Thanks, CJ Assuming your have data in A1 of sheet1 and data in A1 of sheet2 In B1 of sheet2 enter =A1 & sheet1!A1 If you wish a space between enter as =A1 & " " & sheet1!A1 If by "add" you mean "sum" In B1 enter =SUM(A1,sheet1!A1) Gord Dibben MS Excel MVP On Thu, 19 Oct 2006 15:43:06 -0500, "C J" <weshom@comcast.net> wrote: >What is the formula that will add the content of a cell on one ...

Hi, It's OK to copy the formula from one cell to another one within the same sheet. How about that to copy the formula from one Excel file to another one? It seems only the value of that cell will be copied to that file but not the formula inside it. I even have tried to copy the corr. formula within that again but just the copied formula will not work successfully in there. Thks & Rgds, HuaMin -- HuaMin ------------------------------------------------------------------------ HuaMin's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29423 View this thr...

Hi all, I have the following formula which works well: SUMPRODUCT((Main!$G$4:$G$2885 = "I")*(Main!T4:T2885)) but i want to amend it slightly to check if column B equals GL as well - think that is: (Main!$B$4:$B$2885 = "GL") but i don't know how!! Thanks, Kirstie SUMPRODUCT works by multiply numbers (row-by-row) and then adding those individual products up. Your numbers can be actual values and/or logical expressions. The reason your formula works is because the logical expression (Main!$G$4:$G$2885 = "I") evaluates to either TRUE or FALSE whi...

When using the CONCATENATE formula, how do I get a space between the 2 fields in the result cell? Hi =CONCATENATE(A1," ",B1) or slightly less typing =A1 & " " & B1 -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "jkeeton" <jkeeton@discussions.microsoft.com> wrote in message news:A915646B-BB02-46F2-B4D9-B725A1C44467@microsoft.com... > When using the CONCATENATE formula, how do I get a space between the 2 > fields > in the result cell? ...

I need a formula that will determine if information in a database meets two criteria and then total the number of rows that are correct. The column titles are Event type and New/Repeat. I need to be able to distinguish if an event is sports, smerf, or group and then new or repeat. Any help would be appreciated. One way: Array-entered (CTRL-SHIFT-ENTER, or CMD-RETURN): =SUM((A1:A1000={"sports","smerf","group"})*((B1:B1000="new")+ (B1:B1000="repeat"))) In article <3FD727FE-C380-4924-A366-388967B15BA7@microsoft.com>, "...

How do I set a cell value based on a formula in another cell? =IF(D4="P.B.A.",G8,0) ,This works to set the value in the cell the formula is in, say cell A1. I would like to have this formula reside in cell A1 but set the value in cell A2 to (G8,0). Also it would be helpful if I could lock cell A2 based on a False condition from this formula in cell A1. Thanks Gary I note that this entry is also asked and answered in Programming. dingy101 Wrote: > How do I set a cell value based on a formula in another cell? > > > =IF(D4="P.B.A.",G8,0) ,This w...

When I configure Outlook 2003 for RPC over HTTP it requires me to enter username/password again. I have already entered it when I logged into the domain so why should I have to re-enter it? It is very irritating. I am assuming there is some workaround for this annoyance. Does anybody know how to get around this problem or have you all accepted retyping your username/password? Any suggestions would be greatly appreciated. Thanks, Stephen On Sat, 12 Mar 2005 03:35:02 -0800, "Slacker" <Slacker@discussions.microsoft.com> wrote: >When I configure Outlook 2003 for RPC ...

Hi, I really hope someone out there can help me, I am trying to create a formual that will allow me to calculate freight charges. I want to be able to input a weight and a zone and have it come back with the cost. This is basically what the sheet looks like now, Sheet 1 Cell C27 (Weight) 5 Sheet 1 Cell C29 (Zone) 51 Sheet 1 Cell C31-Formula Now based on my data on sheet two using 5lbs and zone 51 should make the answer $13.31. The weights from 1 to 50 are in Column A2:A51 on sheet 2 and the Zones are B1:D:1 and the charges are in Columns B2:B51, C2:C51,D2:D51,E2:E51. None of the formulas I h...

I am trying to sort a column of formulas that consist of cel references. Example: Column: Cell 1 holds: =D10 Cell 2 holds: =D11 Cell 3 holds: =D12 Data: D10=1 D11=2 D12=3 When I try to sort the column of formulas, the formulas change cel references to other cells and mess up the data. How can I sort a column of cells of which all of them contain formula and have the cells keep the references to the right place -- Message posted from http://www.ExcelForum.com Hi- If you write your formulae with absolute references rather tha relative references, you can sort them. Formulae should look ...

I've managed to put together two different formulas from two different sources and it seems to be working okay except in terms of the format of the numbers. The formula is this: =IF(G2="?",TEXT(G2,"$0")&" ttl unknown",G2*I2) The "$0" in there is a remnant from the original. I don't know what to do with it so I've left it in. The purpose of this formula is to deal with situations where a list price is unknown and a user puts a question mark in G2. This formula goes into the totals column but there is no total known so th...

Can an Exchange 2003 Standard edition become a Front-end server or does it have to be Enterprise Editon? Unlike with Exchange 2000, Exchange 2003 Standard Edition can be a front-end server. -- Ed Crowley MVP - Exchange "Protecting the world from PSTs and brick backups!" "Zack" <svoiasgfs@sdlgweg90dflg.com> wrote in message news:%23hBr1ma6GHA.4304@TK2MSFTNGP03.phx.gbl... > Can an Exchange 2003 Standard edition become a Front-end server or does it > have to be Enterprise Editon? > "Zack" <svoiasgfs@sdlgweg90dflg.com> wrote: >Ca...

Cell A1 in Sheet1 holds the result of a concatenated string and reads: =Sheet2!$A$1. How can I make Excel display the value of A1 in sheet 2 in stead of the formula =Sheet2!$A$1 (as a string)? Can anyone help? hi Niels, try the function INDIRECT, e.g. =INDIRECT(A1) Frank Niels Govers wrote: > Cell A1 in Sheet1 holds the result of a concatenated > string and reads: =Sheet2!$A$1. > > How can I make Excel display the value of A1 in sheet 2 in > stead of the formula =Sheet2!$A$1 (as a string)? > > Can anyone help? Hi Niels! Try: =INDIRECT(A1) You can build your ...

This is showing how much of a novice I am, but I'm learning. I need to change this formula so that it not only shows the message if multiples of 84 is not entered but if multiples of 61 is not entered into the same cell. Thanks. =IF(MOD(F21,84)<>0,"Qty in this Row is not in multiples of 84","") Hi! Try this: =IF(MOD(F21,84)=0,"",IF(MOD(F21,61)=0,"","Qty in this Row is not in multiples of 84 or 61")) Biff "Eintsein_mc2" <simonmerks@bigpond.com> wrote in message news:1127014192.905805.63830@o13g2000cwo.googlegrou...

I want to copy formula down many rows but don't want to have to retype row numbers at every different row I assume you're wanting to "build" a cell reference that increments as you copy a formula. Post the formula you want to copy and include a more detailed explanation. -- Biff Microsoft Excel MVP "jimmy" <jimmy@discussions.microsoft.com> wrote in message news:47EB16F7-F84F-4DB1-B1AC-424E28A81953@microsoft.com... >I want to copy formula down many rows but don't want to have to retype row > numbers at every different row ...

On the case entity, I'd like to make a few fields required only when the user select Actions>resolved. If they select to resolve, these fields would become required, but they can save the case without this data while working the case. How would I control the field requirement? Thanks ...

I am new at excell 2003. I am working on a spread sheet and I cannot find the formula I need. My question is based on the following information: Homework average (94) = 15%, Project average (95) = 40%, and Test average = (45%). What is the Final grade? I want to thank you advance for your help. -- larry One way .. Assuming the marks and weighted % are in B2:C4, as below: (a mark of 80 is assumed for "Test average") 94 15% 95 40% 80 45% Put in B5: =SUMPRODUCT(B2:B4,C2:C4) For the sample data, B5 will return: 88.1 -- Rgds Max xl 97 --- GMT+8, 1� 22' N 103� 45' E xde...

I am attempting to setup two columns. One column is adding charges. The other is showing the charges deducted from a starting balance. I am trying to keep track of a cash card as I am spending the funds. -- Thanks in advance for your assistance HankL Put your initial balance in A1 and nothing in B1 In A2 enter: =A1-B2 and copy down As you enter charges in B2 and going down, they will be debitted in column A and the balance will appear. -- Gary''s Student - gsnu200791 "HankL" wrote: > I am attempting to setup two columns. One column is adding charges. The ...

I have a long list of names that i need to seperate out into the teams on different sheets. On the "team" worksheet in column I, I have the team names and I want each on a seperate worksheet. So on worksheet Green I want to get all member, columns A-C and G-H and have them on the Green worksheet. I have lots of data and do not want to use copy and past. THANKS "eechris" <eechris@discussions.microsoft.com> wrote in message news:75BF68CF-639C-4279-A267-ADD8BCFD2B34@microsoft.com... >I have a long list of names that i need to seperate out in...

this is probably a simple preference, but I cannot find it on my new Excel program. When I double click a cell with a formula, I am used to seeing it highlight the cells that are related to this formula. That does not happen with my new Exel. Can someone tell which preference to change? Thanks <Tools> <Options> <Edit> tab, And check or uncheck "Edit Directly In cell". -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! ---------------------------...

Hello all, Is there a way th have all formulas in a sheet shown, so I can print it out with formulas showing? thanks, Confused Man Ctrl + ` -- Regards - Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy "Confused Man" <bfbj@iup.edu> wrote in message news:FcCdnSCTJvHTde3fRVn-tw@adelphia.com... > Hello all, > > Is there a way th have all formulas in a sheet shown, so I can print it out > with formulas showing? > > thanks, > Confused Man > > "Confused Man" <bfbj@iup.edu>ha scritto nel messaggio FcCdnSC...

I keep getting a formula showing in the cell after I edit i (occasionally). Show formulas is turned off and edit in cell is on. How can I make the formula go awaw and simply show the results whic when edited the results shows correctly? -- Message posted from http://www.ExcelForum.com Hi probably the cell is formated as 'Text' change the cell format to 'General' and re-enter your formula -- Regards Frank Kabel Frankfurt, Germany > I keep getting a formula showing in the cell after I edit it > (occasionally). Show formulas is turned off and edit in cell is on. >...

I do not access to Lotus Smartsuite and need to import an old Lotus wk4 spreadsheet into Excel with the formuale intact. It would be huge hassle to recreate it and I am not going to invest in Smartsuite. thanks hi 2007 does not support lotus. so you need to find someone with lotus or check in to open office. it's free. http://openoffice.org regards FSt1 "jrj19" wrote: > I do not access to Lotus Smartsuite and need to import an old Lotus wk4 > spreadsheet into Excel with the formuale intact. It would be huge hassle to > recreate it and I am not going to invest i...

We are using Outlook 2007 and Exchange 2003 SP3 (I believe) and one of the employee accidently deleted a folder. When I click on "Deleted Items" and then select Tools\Recover Deleted Items, I don't see the folder listed but when I click on Junk E-mail and then select Tools\Recover Deleted Items and I found the folder listed in there. So I select the folder to recover I got a message that I require to have permission to recover some or all of the items or contact Admin something like that. How can I find or set up a permission to enable to recover the folder? Than...

We want the Outlook client to require users to select a value (contact, account, etc.) for the "regarding" field when an email is promoted. If I customize the CRM “email” entity so that its “regardingobjectid” attribute is “Business Required”, will that do the trick? ...