 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / October 2006Extract Symbol
Using Excel 2003 I have a cell (B3) that has a value of >0.30%. Then I have another cell (B5) that has a value of 0.35%. I want to know the difference between the two values, which is 0.05%. I cannot just use the formula =B5-B3 because of the greater than symbol in B3. I was thinking of using a different cell (let's say C3) and then create a formula for that cell to extract the > symbol and then use that cell for my difference and then hide that column. What would be the formula to hide the > symbol? Any help would be greatly appreciated Hi Karen, =VALUE(SUBSTITUTE(B3,">","")) HTH Cheers Carim Thank you for your help > Hi Karen, > [quoted text clipped - 3 lines] > Cheers > Carim One way: =B5-RIGHT(B3,LEN(B3)-1) Regards, Paul > Using Excel 2003 > [quoted text clipped - 8 lines] > > Any help would be greatly appreciated Thank you - It's works great! > One way: > [quoted text clipped - 15 lines] > > > > Any help would be greatly appreciated If you have time, would you please break this formula down into laymen's terms? Thank you again, Karen > One way: > [quoted text clipped - 15 lines] > > > > Any help would be greatly appreciated This determines the number of characters (including spaces) in B3, which equals 6. =Len(B3) Since you want to remove the first character, then you need to subtract 1: =Len(B3)-1 This returns the 5 right-most characters, which is 0.30%. =Right(B3,5) Now just replace the '5' with the formula we used to determine that number. =Right(B3,Len(B3)-1) Now you just need to subtract from B5, hence: =B5-RIGHT(B3,LEN(B3)-1) HTH, Paul > If you have time, would you please break this formula down into laymen's > terms? [quoted text clipped - 24 lines] >> > >> > Any help would be greatly appreciated Thank you - It helps to understand the formula - You made my day! > This determines the number of characters (including spaces) in B3, which > equals 6. [quoted text clipped - 42 lines] > >> > > >> > Any help would be greatly appreciated Try this: =B5-MID(B3,2,99) > Using Excel 2003 > [quoted text clipped - 7 lines] > > Any help would be greatly appreciated Thank you for your help > Try this: > [quoted text clipped - 11 lines] > > > > Any help would be greatly appreciated |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.