Formula with Text

P

phardy

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:)
 
P

Pete_UK

How can you multiply "BW" by 100% or by 25% ?

A bit more clarity needed regarding your data, please.

Pete
 
D

David Biddulph

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.
 
P

phardy

THanks... I left that out sorry.. I am multiply by c1. I will try your
response below and just change b1 to c1 THANKS
 
P

phardy

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
 
D

David Biddulph

"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?
 
P

phardy

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
 
G

Gord Dibben

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
 
D

David Biddulph

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!
 
P

phardy

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%
 
G

Gord Dibben

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%
Click to expand...
=IF A1 has BW Multiple C1 By 100% IF A1 does NOT have BW Multiply C1 by 25%
Click to expand...

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
 
Top