a h.s.l.@ £3.80 mtr & 10sq m are fitted whats the formula help
 

i'm trying to enter a formula for an invoice in excell h.s.landing @ 3.80 a
sq mtr x 10sq mtrs would be £38.00. how do i write that as a formula so that
every time i enter the word h.s.l. and enter the amount of sq mtrs fitted i
would get the cost automatically on the invioce

a h.s.l.@ £3.80 mtr & 10sq m are fitted whats the formula help
 

Sonia,

The problem with using "h.s.l" to activate the formula is that to Excel:

h.s.l..
hsl
h.s.l
hs.l.
h,s.l.

are all different entries only the first of which woule trigger the formula.
To get around this and with "h.s.l." in F7 and the amont in H3 try:

=IF(SUM(IF(FIND({"H","S","L"},UPPER(F7)),1,0))=3,H 3*3.8,"")

It would also be better if the 3.8 was not hard coded into the formula so
that it can be changed easily so with the money in G3 the formula would be:

=IF(SUM(IF(FIND({"H","S","L"},UPPER(F7)),1,0))=3,H 3*G3,"")

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"SONIA NEW TO FORMULA'S HELP" <SONIA NEW TO FORMULA'S
wrote in message
...
i'm trying to enter a formula for an invoice in excell h.s.landing @
3.80 a
sq mtr x 10sq mtrs would be £38.00. how do i write that as a formula so
that
every time i enter the word h.s.l. and enter the amount of sq mtrs fitted
i
would get the cost automatically on the invioce