Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |