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

  • Thread starter SONIA NEW TO FORMULA'S HELP
  • Start date
S

SONIA NEW TO FORMULA'S 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
 
S

Sandy Mann

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,H3*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,H3*G3,"")

--
HTH

Sandy
In Perth, the ancient capital of Scotland

[email protected]
[email protected] with @tiscali.co.uk


"SONIA NEW TO FORMULA'S HELP" <SONIA NEW TO FORMULA'S
[email protected]> wrote in message
news:[email protected]...
 
Top