 |
 | 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 / General Excel Questions / March 2008Formula with Text
Hello, I am trying to right a formula that will read text. The formula would be if BW is in the cell then multiply by 100% if BW is not in the text field multiply by 25% Does anyone have any suggestions? Thanks for any help:) How can you multiply "BW" by 100% or by 25% ? A bit more clarity needed regarding your data, please. Pete > Hello, > I am trying to right a formula that will read text. The formula would be [quoted text clipped - 4 lines] > Does anyone have any suggestions? > Thanks for any help:) Multiply what by 100% or 25%? If you are looking at the content of A1 for your text, and multiplying B1, then try =IF(ISNUMBER(FIND("BW",A1)),B1,B1*25%) if you want the search to be case sensitive, or =IF(ISNUMBER(SEARCH("BW",A1)),B1,B1*25%) if not case sensitive. -- David Biddulph > Hello, > I am trying to right a formula that will read text. The formula would be [quoted text clipped - 4 lines] > Does anyone have any suggestions? > Thanks for any help:) THanks... I left that out sorry.. I am multiply by c1. I will try your response below and just change b1 to c1 THANKS > Multiply what by 100% or 25%? > If you are looking at the content of A1 for your text, and multiplying B1, [quoted text clipped - 13 lines] > > Does anyone have any suggestions? > > Thanks for any help:) Hello, I am looking at the content in A1 as text and multiplying C1. I want the formula to see BW and if BW is in A1 then multiply by 100% in C1 but if there is no BW in A1 I want to multiply 25% in C1 Does this help. I tried the formula below but did not work > Multiply what by 100% or 25%? > If you are looking at the content of A1 for your text, and multiplying B1, [quoted text clipped - 13 lines] > > Does anyone have any suggestions? > > Thanks for any help:) "Did not work" is not sufficient detail for anyone to help you to find out what error you have made. The formulae I gave *do* work, and you said you were going to change my B1 references to C1, so tell us what formula you have in your cell, what values you have in the input cells, what error messages (if any) you are getting, if not what result you are getting, and what result you were expecting. Depending on the result you are getting, one thing you might check is whether you really do have a number in C1, or whether you might have text that looks like a number. What does =ISNUMBER(C1) give? What does =ISTEXT(C1) give?  SignatureDavid Biddulph > Hello, > I am looking at the content in A1 as text and multiplying C1. I want the [quoted text clipped - 23 lines] >> > Does anyone have any suggestions? >> > Thanks for any help:) Hi I am sorry i didn't mean it doesn't work ... it is not given the right info. I am looking for a formula that will do the follwoing: Look in A1 if the letters BW is in the text than take C1 which has an amount in it and multiply by 100% if A1 does not have BW in the text then take C1 and have it multiply by 25%- COLUMN D will be were the formula will be written. so something like if A1 has BW then multiply what is in C1 by 100% to give the total or If A1 does not contain BW than multiply C1 by 25% to give a total BW > "Did not work" is not sufficient detail for anyone to help you to find out > what error you have made. [quoted text clipped - 34 lines] > >> > Does anyone have any suggestions? > >> > Thanks for any help:) My turn...............now that sufficient detail has been posted<g> In D1 enter =IF(A1="BW",C1*1,C1*.25) Gord Dibben MS Excel MVP >Hi I am sorry i didn't mean it doesn't work ... it is not given the right >info. I am looking for a formula that will do the follwoing: [quoted text clipped - 46 lines] >> >> > Does anyone have any suggestions? >> >> > Thanks for any help:) Hello Gord, Thank you for your response. We are so close to getting this formula correct. The formula below works except that if there is no BW in the A1 Column i need it to multiply C1 by 100% Basically i am trying to take A1 which is where the text info is see if BW is there if BW it is there then C1 needs to multiply by 100% if BW is not there C1 needs to be multiply by 25% ---- I am not sure if this can be done. It is kinda trricky. I have in Column A -All Text I have in Column C-Dollar Amounts $ =IF A1 has BW Multiple C1 By 100% IF A1 does NOT have BW Multiply C1 by 25% > My turn...............now that sufficient detail has been posted<g> > [quoted text clipped - 52 lines] > >> >> > Does anyone have any suggestions? > >> >> > Thanks for any help:) You have two contrary statements in this last post. >The formula below works except that if there is no BW in the A1 >Column i need it to multiply C1 by 100% >=IF A1 has BW Multiple C1 By 100% IF A1 does NOT have BW Multiply C1 by 25% My formula covers the second statement which was in your original post.. Did you try it? =IF(A1="BW",C1*1,C1*.25) Break it down into two parts........... =IF(A1="BW",C1*1) if A1 = BW multiply C1 by 100% =IF(A1<>"BW",C1*.25) if A1 does not equal BW multiply C1 ny 25% Gord >Hello Gord, > [quoted text clipped - 68 lines] >> >> >> > Does anyone have any suggestions? >> >> >> > Thanks for any help:) But you still haven't answered the questions [and "it is not given the right info" is as unhelpful a collection of diagnostic information as "did not work"], so we still can't help you! Changing the B1 references to C1, the formulae I gave earlier become: =IF(ISNUMBER(FIND("BW",A1)),C1,C1*25%) if you want the search to be case sensitive, or =IF(ISNUMBER(SEARCH("BW",A1)),C1,C1*25%) if not case sensitive. Now *please* tell us what formula you are using, and answer the questions I asked below! -- David Biddulph > Hi I am sorry i didn't mean it doesn't work ... it is not given the right > info. I am looking for a formula that will do the follwoing: [quoted text clipped - 57 lines] >> >> > Does anyone have any suggestions? >> >> > Thanks for any help:) |
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.