tag:blogger.com,1999:blog-1869924468172210809.post6189169221455801116..comments2022-08-04T17:21:18.320+01:00Comments on Not Just Numbers: EXCEL TIP: The dollar sign ($) in a formula - Fixing cell referencesGlen Feechanhttp://www.blogger.com/profile/12461985809302036952noreply@blogger.comBlogger175125tag:blogger.com,1999:blog-1869924468172210809.post-54183699923529437042022-08-04T16:51:11.298+01:002022-08-04T16:51:11.298+01:00Very efficiently written information. It will be b...Very efficiently written information. It will be beneficial to anybody who utilizes it, including me. Keep up the good work. For sure i will check out more posts. This site seems to get a good amount of visitors.<br />MZhttps://www.blogger.com/profile/01831608476491741405noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-62750188771139469242019-04-27T22:31:16.623+01:002019-04-27T22:31:16.623+01:00Thank you very much, it has been useful to meThank you very much, it has been useful to meAnonymoushttps://www.blogger.com/profile/04014369469257450288noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-46052441336248353642018-12-04T14:22:49.595+00:002018-12-04T14:22:49.595+00:00Thank you!Thank you!CHhttps://www.blogger.com/profile/11813060357397649282noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-27510662280725635712018-01-19T19:02:12.304+00:002018-01-19T19:02:12.304+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.Anonymoushttps://www.blogger.com/profile/02367021361323212996noreply@blogger.comtag: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.Anonymoushttps://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 resovledAnonymoushttps://www.blogger.com/profile/00676902520745706107noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-57419262374423005282017-11-23T12:46:46.998+00:002017-11-23T12:46:46.998+00:00THANKS PROBLEM RESOLVEDTHANKS PROBLEM RESOLVEDAnonymoushttps://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!Anonymoushttps://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 lotAnonymoushttps://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 !Someonehttps://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!Someonehttps://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 !Anonymoushttps://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 )SNMhttps://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. Amgadhttps://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.com