Calculating on alphabetic cell content

Hi,

A selection of 4 different letters in a column representing different values
to be used in a formula shall be run through. The calculated result of each
cell in the column shall be placed in the cell next to the read one that
holds the letter.

Thanks in advance.

Hi

i think you're after the COUNTIF function
with your column of letters in A1:A100
and the letter you're interested in in C1
then in D1
=COUNTIF(A1:A100,C1)

this will count the number of times the value in C1 occurs in your range.

If this isn't what you're after, could you type out a few examples of your
data and what you want to see in a reply post (please do not attach a
workbook)

Regards
JulieD

"Thorkild" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> A selection of 4 different letters in a column representing different
> values
> to be used in a formula shall be run through. The calculated result of
> each
> cell in the column shall be placed in the cell next to the read one that
> holds the letter.
>
> Thanks in advance.

Specified problem description.

Each cell in a column is containing a letter representing a discount value.
This discount value shall be converted into a percentage figure, that again
can be put into a currency calculating formula that finally puts the sales
prize next to the original cell holding the letter.

"JulieD" skrev:

> Hi
>
> i think you're after the COUNTIF function
> with your column of letters in A1:A100
> and the letter you're interested in in C1
> then in D1
> =COUNTIF(A1:A100,C1)
>
> this will count the number of times the value in C1 occurs in your range.
>
> If this isn't what you're after, could you type out a few examples of your
> data and what you want to see in a reply post (please do not attach a
> workbook)
>
> Regards
> JulieD
>
> "Thorkild" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> >
> > A selection of 4 different letters in a column representing different
> > values
> > to be used in a formula shall be run through. The calculated result of
> > each
> > cell in the column shall be placed in the cell next to the read one that
> > holds the letter.
> >
> > Thanks in advance.
>
>
>

Hi

i think this can be done - but it would help if you could type out an
example or two, with the desired calculations and results.

Cheers
JulieD

"Thorkild" <[email protected]> wrote in message
news:[email protected]...
> Specified problem description.
>
> Each cell in a column is containing a letter representing a discount
> value.
> This discount value shall be converted into a percentage figure, that
> again
> can be put into a currency calculating formula that finally puts the sales
> prize next to the original cell holding the letter.
>
> "JulieD" skrev:
>
>> Hi
>>
>> i think you're after the COUNTIF function
>> with your column of letters in A1:A100
>> and the letter you're interested in in C1
>> then in D1
>> =COUNTIF(A1:A100,C1)
>>
>> this will count the number of times the value in C1 occurs in your range.
>>
>> If this isn't what you're after, could you type out a few examples of
>> your
>> data and what you want to see in a reply post (please do not attach a
>> workbook)
>>
>> Regards
>> JulieD
>>
>> "Thorkild" <[email protected]> wrote in message
>> news:[email protected]...
>> > Hi,
>> >
>> > A selection of 4 different letters in a column representing different
>> > values
>> > to be used in a formula shall be run through. The calculated result of
>> > each
>> > cell in the column shall be placed in the cell next to the read one
>> > that
>> > holds the letter.
>> >
>> > Thanks in advance.
>>
>>
>>

Hi
Hope this works.
The received pricelist holding only column A and B shall be appended column
C to G
The results of the calculated prices from column A shall be displayed in
column C and D. DCFactor (DomesticCurrency factor) and $Factor are in respect
to the € price in column A and are like cells G2 and H2 fixed values.
The actual problem is the letter presentation in column B.
(Column A is >1000 rows deep, some are blank)

A B C D E F
G H
€ Discount $ DomCurr DCFactor $Factor Shipment
Profit
2 609 A 7.54 7.0
5% 40%
3 640 C
4 640 C
5 1161 C
6
7 696 C 770 5392
8 696 B 715 5007
9 729 B
10 729 C
11 952 C
12 952 A
13 1224 C
14 1224 A
15
16 760 C
17 760 C

Discount A=40%
Discount B=35%
Discount C=30%
DiscountFactor is EITHER 40% or 35% or 30% depending on the row being
calculated.

FormulaDC: (((A2*DCFactor)-DiscountFactor)+Shipment)+Profit 'result in D2
Formula$: D2/$Factor
'result in C2


Cheers
Thorkild



"JulieD" skrev:

> Hi
>
> i think this can be done - but it would help if you could type out an
> example or two, with the desired calculations and results.
>
> Cheers
> JulieD
>
> "Thorkild" <[email protected]> wrote in message
> news:[email protected]...
> > Specified problem description.
> >
> > Each cell in a column is containing a letter representing a discount
> > value.
> > This discount value shall be converted into a percentage figure, that
> > again
> > can be put into a currency calculating formula that finally puts the sales
> > prize next to the original cell holding the letter.
> >
> > "JulieD" skrev:
> >
> >> Hi
> >>
> >> i think you're after the COUNTIF function
> >> with your column of letters in A1:A100
> >> and the letter you're interested in in C1
> >> then in D1
> >> =COUNTIF(A1:A100,C1)
> >>
> >> this will count the number of times the value in C1 occurs in your range.
> >>
> >> If this isn't what you're after, could you type out a few examples of
> >> your
> >> data and what you want to see in a reply post (please do not attach a
> >> workbook)
> >>
> >> Regards
> >> JulieD
> >>
> >> "Thorkild" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > Hi,
> >> >
> >> > A selection of 4 different letters in a column representing different
> >> > values
> >> > to be used in a formula shall be run through. The calculated result of
> >> > each
> >> > cell in the column shall be placed in the cell next to the read one
> >> > that
> >> > holds the letter.
> >> >
> >> > Thanks in advance.
> >>
> >>
> >>
>
>
>

Hi

the line wrap got a bit difficult, but i think i know what you're after
(maybe)
two options
=IF(B2="A",40%,IF(B2="B",35%,IF(B2="C",30%,0)))

this can then be used in a formula e.g.
=A2*IF(B2="A",40%,IF(B2="B",35%,IF(B2="C",30%,0)))

alternatively you can use the VLOOKUP function
(have a table somewhere which lists in the first column the letters and in
the second column the %)
e.g. (on sheet2)
.......A.............B
1...Code.....Percent
2....A............40%
3.....B...........35%
4.....C...........30%

and then use the following formula
=VLOOKUP(B2,Sheet2!$A$2:$B$4,2,0)
again this can be embedded in a formula

=A2*VLOOKUP(B2,Sheet2!$A$2:$B$4,2,0)

---
there are other alternatives, but do either of these help you?

Cheers
JulieD


"Thorkild" <[email protected]> wrote in message
news:[email protected]...
> Hi
> Hope this works.
> The received pricelist holding only column A and B shall be appended
> column
> C to G
> The results of the calculated prices from column A shall be displayed in
> column C and D. DCFactor (DomesticCurrency factor) and $Factor are in
> respect
> to the ? price in column A and are like cells G2 and H2 fixed values.
> The actual problem is the letter presentation in column B.
> (Column A is >1000 rows deep, some are blank)
>
> A B C D E F
> G H
> ? Discount $ DomCurr DCFactor $Factor Shipment
> Profit
> 2 609 A 7.54 7.0
> 5% 40%
> 3 640 C
> 4 640 C
> 5 1161 C
> 6
> 7 696 C 770 5392
> 8 696 B 715 5007
> 9 729 B
> 10 729 C
> 11 952 C
> 12 952 A
> 13 1224 C
> 14 1224 A
> 15
> 16 760 C
> 17 760 C
>
> Discount A=40%
> Discount B=35%
> Discount C=30%
> DiscountFactor is EITHER 40% or 35% or 30% depending on the row being
> calculated.
>
> FormulaDC: (((A2*DCFactor)-DiscountFactor)+Shipment)+Profit 'result
> in D2
> Formula$: D2/$Factor
> 'result in C2
>
>
> Cheers
> Thorkild
>
>
>
> "JulieD" skrev:
>
>> Hi
>>
>> i think this can be done - but it would help if you could type out an
>> example or two, with the desired calculations and results.
>>
>> Cheers
>> JulieD
>>
>> "Thorkild" <[email protected]> wrote in message
>> news:[email protected]...
>> > Specified problem description.
>> >
>> > Each cell in a column is containing a letter representing a discount
>> > value.
>> > This discount value shall be converted into a percentage figure, that
>> > again
>> > can be put into a currency calculating formula that finally puts the
>> > sales
>> > prize next to the original cell holding the letter.
>> >
>> > "JulieD" skrev:
>> >
>> >> Hi
>> >>
>> >> i think you're after the COUNTIF function
>> >> with your column of letters in A1:A100
>> >> and the letter you're interested in in C1
>> >> then in D1
>> >> =COUNTIF(A1:A100,C1)
>> >>
>> >> this will count the number of times the value in C1 occurs in your
>> >> range.
>> >>
>> >> If this isn't what you're after, could you type out a few examples of
>> >> your
>> >> data and what you want to see in a reply post (please do not attach a
>> >> workbook)
>> >>
>> >> Regards
>> >> JulieD
>> >>
>> >> "Thorkild" <[email protected]> wrote in message
>> >> news:[email protected]...
>> >> > Hi,
>> >> >
>> >> > A selection of 4 different letters in a column representing
>> >> > different
>> >> > values
>> >> > to be used in a formula shall be run through. The calculated result
>> >> > of
>> >> > each
>> >> > cell in the column shall be placed in the cell next to the read one
>> >> > that
>> >> > holds the letter.
>> >> >
>> >> > Thanks in advance.
>> >>
>> >>
>> >>
>>
>>
>>