tag:blogger.com,1999:blog-1869924468172210809.post6189169221455801116..comments2018-01-20T10:46:17.350+00:00Comments on Not Just Numbers: EXCEL TIP: The dollar sign ($) in a formula - Fixing cell referencesGlen Feechanhttp://www.blogger.com/profile/12461985809302036952noreply@blogger.comBlogger170125tag:blogger.com,1999:blog-1869924468172210809.post-21886746166819446982018-01-19T19:01:57.771+00:002018-01-19T19:01:57.771+00:00Very helpful indeed... I was amazed by what i just...Very helpful indeed... I was amazed by what i just read about your explanation. I have encountered this so many times and long time ago. I have just realised its function just now. Thank you so much. it is a great help. I hope you will not stop spreading what you have learned.Unknownhttps://www.blogger.com/profile/02367021361323212996noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-56620162513332043372017-11-23T12:47:58.739+00:002017-11-23T12:47:58.739+00:00Thanks problem resovledThanks problem resovledV.V.P Narasimhamhttps://www.blogger.com/profile/00676902520745706107noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-71289578124642567862017-11-19T14:59:59.962+00:002017-11-19T14:59:59.962+00:00Thx bro!Thx bro!Zahid Efehttps://www.blogger.com/profile/11965597837619898183noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-175061502625816052017-11-18T17:30:21.973+00:002017-11-18T17:30:21.973+00:00Great, thanks, helped me a lotGreat, thanks, helped me a lotUnknownhttps://www.blogger.com/profile/12773033146045037992noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-53327021904391930752017-08-19T06:52:14.522+01:002017-08-19T06:52:14.522+01:00Thank you very valuable infoThank you very valuable infoAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-81422939710084744092017-06-13T09:43:47.226+01:002017-06-13T09:43:47.226+01:00Thanks, I just used it and really love it.Thanks, I just used it and really love it.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-56900315514194407772017-05-22T20:43:46.817+01:002017-05-22T20:43:46.817+01:00Also a simple VBA function can accomplish this and...Also a simple VBA function can accomplish this and is actually the starter example (think "hello world") for many VBA tutorials.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-78116414297090181622017-03-29T17:08:47.521+01:002017-03-29T17:08:47.521+01:00Thanks a lo!! That's great !Thanks a lo!! That's great !Chhabi Acharyahttps://www.blogger.com/profile/04852814382570438438noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-8647752904238338372017-03-29T15:25:12.310+01:002017-03-29T15:25:12.310+01:00If your sale price is in cell A1 then:
=50+IF($A$...If your sale price is in cell A1 then:<br /><br />=50+IF($A$1<=10000,0,$A$1*.00018)Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-27090553966113539322017-03-29T15:17:25.111+01:002017-03-29T15:17:25.111+01:00I am trying to calculate a formula that I want a f...I am trying to calculate a formula that I want a fix value and then the formula calculated by a percentage. Therefore if my sale price is < or = than $10,000.00 my fee is $50.00 but if my sale price is > or = $10,000.00 my fee is $50.00 plus 0.018% of sale priceAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-71990638221937537682017-03-28T02:35:56.917+01:002017-03-28T02:35:56.917+01:00Assuming you just the value of A1 to appear if it ...Assuming you just the value of A1 to appear if it is 40 or more then the formula in B1 should be:<br />=IF(A1<40,A1&"*",A1)Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-86354689776854395982017-03-28T01:41:39.503+01:002017-03-28T01:41:39.503+01:00Hello, there!
I want someone to help me formulati...Hello, there!<br />I want someone to help me formulating for the following condition :<br />If A1 is less than 40, the value in A1 should return together with an asterisk. For example, 19 in A1 should appear in B1 as 19*.<br /><br />Thanks in advance!Chhabi Acharyahttps://www.blogger.com/profile/04852814382570438438noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-11692471252226838292017-03-19T11:35:17.438+00:002017-03-19T11:35:17.438+00:00Thanks , very helpful !Thanks , very helpful !Daniel Touhttps://www.blogger.com/profile/16018948335036780958noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-80149241807626263172017-01-26T11:09:28.459+00:002017-01-26T11:09:28.459+00:00Brilliant! so clear and concise and just helped on...Brilliant! so clear and concise and just helped on a deadline submission of a tender. Thank you so much for sharing your knowledge.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-64987400114815229662017-01-21T16:02:01.394+00:002017-01-21T16:02:01.394+00:00I don't understand the questionI don't understand the questionGlen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-78703079628785803092017-01-21T15:57:45.502+00:002017-01-21T15:57:45.502+00:00Sir i want fixed in cell about $0.00 Ex: A1= $0.00...Sir i want fixed in cell about $0.00 Ex: A1= $0.00 ( don't delete in cell except values )YeS.YeN.YeM. Srhttps://www.blogger.com/profile/05145383215943181140noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-53333554114731369982017-01-17T10:01:27.352+00:002017-01-17T10:01:27.352+00:00Just put the $ in front of the row rather than th...Just put the $ in front of the row rather than the column, i.e.<br /><br />E$1Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-1731982476731561412017-01-17T09:54:31.494+00:002017-01-17T09:54:31.494+00:00Hello Sir,
$ fix Column E1, E2, E3
If i want fix r...Hello Sir,<br />$ fix Column E1, E2, E3<br />If i want fix row E1, F1, G1.<br />Thank you. Amgad Abadirhttps://www.blogger.com/profile/09535009642437070227noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-27342768636102519842017-01-11T09:25:47.802+00:002017-01-11T09:25:47.802+00:00yeah, thanks for your post. I think i found out my...yeah, thanks for your post. I think i found out my problem, I have fixed and everything is ok now,andro dumpperhttp://appforpc1.com/androdumpper-wps-connect-download-for-pcwindow/noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-31585754568462852762017-01-05T01:27:12.489+00:002017-01-05T01:27:12.489+00:00thanks a lot for your support. I will try itthanks a lot for your support. I will try itRichard Nicolehttp://www.jiotvapp.com/noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-22837749861408856042017-01-04T06:32:31.916+00:002017-01-04T06:32:31.916+00:00You should be able to do what you are after using ...You should be able to do what you are after using a dynamic range. Open the Name Manager on the Formula ribbon, and add a new range (let's call it dropdown), and enter your formula as the range area. Dollar rules apply, so if you don't add the dollars, the reference will be relative to the currently active cell - for example if you have cell B2 selected and you enter =A2 as your range definition, your range will always be the cell to the left of the active cell. If you enter =$A2, the range will always be the cell in column A of the same row as the active cell, etc.<br />Once you have created the range, you just enter its name preceded by the equals sign as the list in your data validation, e.g. =dropdown.Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-28468093340458228452017-01-04T04:01:44.276+00:002017-01-04T04:01:44.276+00:00Hi,many thanks for your post. I got one question:
...Hi,many thanks for your post. I got one question:<br /> for Data Validation -> List, as source, instead of 23 in '=$K$6:$K23', i want to give a formula, for example, I want to give something like '=$K$6:$K(VLOOKUP(C3,N2:P9,2))', is it possible? If so, what is the right format? thanks for any helpRichard Nicolehttp://www.jiotvapp.com/noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-63724158612106545522016-11-25T06:03:05.460+00:002016-11-25T06:03:05.460+00:00thnqthnqAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-87188224603363705802016-11-15T20:21:12.933+00:002016-11-15T20:21:12.933+00:00You can achieve the same thing with R1C1 referenci...You can achieve the same thing with R1C1 referencing by using the actual row and column numbers (no square brackets) rather than the relative square brackets you've used in your example. e.g.<br /><br />=R2C4<br /><br />is the same as<br /><br />=$B$4Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-30074962054145990372016-11-15T10:26:40.525+00:002016-11-15T10:26:40.525+00:00Does the dollar sign for fixing the collumn/row al...Does the dollar sign for fixing the collumn/row also work in row/collumn numericall reference style sheet ? (E. g. =R[-1]C+RC[-2]; newest version of office) I am afraid not...Anonymousnoreply@blogger.com