Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula with Text
THanks... I left that out sorry.. I am multiply by c1. I will try your
response below and just change b1 to c1 THANKS "David Biddulph" wrote: 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 "phardy" wrote in message ... 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:) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Text String: Formatting Text and Numbers? | Excel Discussion (Misc queries) | |||
Link to text and return text into a formula? | Excel Worksheet Functions | |||
Excel:Get concatenated text to be recognised as formula not text? | Excel Discussion (Misc queries) | |||
Formula to count text and alert me if a text appears more than twi | Excel Discussion (Misc queries) | |||
match cell text with text in formula | Excel Worksheet Functions |