On Aug 19, 1:23*pm, Jeffrey <jeffre...@dimond.co.nz> wrote:
> On Aug 19, 1:02*pm, Jeffrey <jeffre...@dimond.co.nz> wrote:
>
>
>
>
>
> > On Aug 19, 11:01*am, Gary''s Student
>
> > <GarysStud...@discussions.microsoft.com> 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
|
Similar Threads
