Formula with Text

[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

 

[Pete_UK]

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

A bit more clarity needed regarding your data, please.

Pete

 

[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

 

[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

 

[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

 

[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

 

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

 

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

=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