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