countif or please advice
 

good day,

I have two sentence which may appear in the same cell, see below: and
I would like to reflect respective dollar value for these
statements. If the sentence has "supply & fit"
then it will reflect a supply and fit price in cell A1 for example. of
if
the sentece has "supply only" then it will reflect the supply only
price. Noticed that ***** varies (it could be low, medium,
low and medium, high, very high).


Sentence 1
We have pleasure in submitting our quotation for a Supply & Fit in a
***** Wind Zone as per NZS 3604 as below:


Sentence 2
We have pleasure in submitting our quotation for a Supply Only in a
***** Wind Zone as per NZS 3604 as below:


thanks in advance.


Jeff

countif or please advice
 

This may be of no help at all, but...

Say A1 contains the supply & fit price
and
A2 contains the supply only price

Say B1 contains the sentence. The in C1 enter:

=IF(LEN(SUBSTITUTE(B1,"supply only",""))=LEN(B1),A1,A2)

this says that if the phrase "supply only" is somewhere in cell B1, the
value in A2 is picked, otherwise the value in A1.
--
Gary''s Student - gsnu2007k


"Jeffrey" wrote:

good day,

I have two sentence which may appear in the same cell, see below: and
I would like to reflect respective dollar value for these
statements. If the sentence has "supply & fit"
then it will reflect a supply and fit price in cell A1 for example. of
if
the sentece has "supply only" then it will reflect the supply only
price. Noticed that ***** varies (it could be low, medium,
low and medium, high, very high).


Sentence 1
We have pleasure in submitting our quotation for a Supply & Fit in a
***** Wind Zone as per NZS 3604 as below:


Sentence 2
We have pleasure in submitting our quotation for a Supply Only in a
***** Wind Zone as per NZS 3604 as below:


thanks in advance.


Jeff

countif or please advice
 

On Aug 19, 11:01*am, Gary''s Student
wrote:
This may be of no help at all, but...

Say A1 contains the supply & fit price
and
A2 contains the supply only price

Say B1 contains the sentence. *The in C1 enter:

=IF(LEN(SUBSTITUTE(B1,"supply only",""))=LEN(B1),A1,A2)

this says that if the phrase "supply only" is somewhere in cell B1, the
value in A2 is picked, otherwise the value in A1.
--
Gary''s Student - gsnu2007k



"Jeffrey" wrote:
good day,

I have two sentence which may appear in the same cell, see below: and
I would like to reflect respective *dollar value for these
statements. *If the sentence has "supply & fit"
then it will reflect a supply and fit price in cell A1 for example. of
if
the sentece has "supply only" then it will reflect the supply only
price. *Noticed that ***** varies (it could be low, medium,
low and medium, high, very high).

Sentence 1
We have pleasure in submitting our quotation for a Supply & Fit in a
***** Wind Zone as per NZS 3604 as below:

Sentence 2
We have pleasure in submitting our quotation for a Supply Only in a
***** Wind Zone as per NZS 3604 as below:

thanks in advance.

Jeff- Hide quoted text -

- Show quoted text -


Hi Gary,

This is brilliant. I will keep this trick in my heart.

cheers.

jeff

countif or please advice
 

On Aug 19, 1:02*pm, Jeffrey wrote:
On Aug 19, 11:01*am, Gary''s Student





wrote:
This may be of no help at all, but...

Say A1 contains the supply & fit price
and
A2 contains the supply only price

Say B1 contains the sentence. *The in C1 enter:

=IF(LEN(SUBSTITUTE(B1,"supply only",""))=LEN(B1),A1,A2)

this says that if the phrase "supply only" is somewhere in cell B1, the
value in A2 is picked, otherwise the value in A1.
--
Gary''s Student - gsnu2007k

"Jeffrey" wrote:
good day,

I have two sentence which may appear in the same cell, see below: and
I would like to reflect respective *dollar value for these
statements. *If the sentence has "supply & fit"
then it will reflect a supply and fit price in cell A1 for example. of
if
the sentece has "supply only" then it will reflect the supply only
price. *Noticed that ***** varies (it could be low, medium,
low and medium, high, very high).

Sentence 1
We have pleasure in submitting our quotation for a Supply & Fit in a
***** Wind Zone as per NZS 3604 as below:

Sentence 2
We have pleasure in submitting our quotation for a Supply Only in a
***** Wind Zone as per NZS 3604 as below:

thanks in advance.

Jeff- Hide quoted text -

- Show quoted text -

Hi Gary,

This is brilliant. *I will keep this trick in my heart.

cheers.

jeff- Hide quoted text -

- Show quoted text -

Hi Gary,

This works when i tried it when using sentence without concantenation.
But my sentence are made up of about 4 contantenations. Please
advice.

thanks.

Jeff

countif or please advice
 

On Aug 19, 1:23*pm, Jeffrey wrote:
On Aug 19, 1:02*pm, Jeffrey wrote:





On Aug 19, 11:01*am, Gary''s Student

wrote:
This may be of no help at all, but...

Say A1 contains the supply & fit price
and
A2 contains the supply only price

Say B1 contains the sentence. *The in C1 enter:

=IF(LEN(SUBSTITUTE(B1,"supply only",""))=LEN(B1),A1,A2)

this says that if the phrase "supply only" is somewhere in cell B1, the
value in A2 is picked, otherwise the value in A1.
--
Gary''s Student - gsnu2007k

"Jeffrey" wrote:
good day,

I have two sentence which may appear in the same cell, see below: and
I would like to reflect respective *dollar value for these
statements. *If the sentence has "supply & fit"
then it will reflect a supply and fit price in cell A1 for example. of
if
the sentece has "supply only" then it will reflect the supply only
price. *Noticed that ***** varies (it could be low, medium,
low and medium, high, very high).

Sentence 1
We have pleasure in submitting our quotation for a Supply & Fit in a
***** Wind Zone as per NZS 3604 as below:

Sentence 2
We have pleasure in submitting our quotation for a Supply Only in a
***** Wind Zone as per NZS 3604 as below:

thanks in advance.

Jeff- Hide quoted text -

- Show quoted text -

Hi Gary,

This is brilliant. *I will keep this trick in my heart.

cheers.

jeff- Hide quoted text -

- Show quoted text -

Hi Gary,

This works when i tried it when using sentence without concantenation.
But my sentence are made up of about 4 contantenations. *Please
advice.

thanks.

Jeff- Hide quoted text -

- Show quoted text -

Hi Gary,

Hey just want to let you know that this formula works even in
concantenated sentence. THANKS MUCH.

JEFF