Have it solved, thanks to everyone who replied, your help was much
appreciated, and a special thank you to Mangesh.
Best regards,
Eamon
"Eamon" wrote in message
...
Mangesh,
Your formula gets rid of the #VALUE! Error. Thank you.
See below for detail of how the spreadsheet is laid out.
Potential problem now.
1) If someone just purchases a part from the garage, I am getting #VALUE
for TAX G47
Or
2) If someone for example had a minor repair carried out that did not
require any parts, just labour I am getting #VALUE for TAX G47
When parts and labour are used it works fine.
Any suggestions to correct this please.
In cells B17:G43 I have parts that the garage may sell or are used in
repairs.
Columns:
B Code
C Product Description
D Format
E Price
F Quantity
G Total
In cells A44:D48 I have details of Labor
Columns:
A Service Person
B Hours
C Rate
D Amount
D49 (TOTAL) =IF(SUM(E45:E48),SUM(E45:E48),"")
G44 (PARTS) =IF(SUM(G17:G43),SUM(G17:G43),"")
G45 (LABOR) =IF(SUM(E49),E49,"")
G46 (SUB TOTAL) =IF(SUM(G43:G45),SUM(G43:G45),"")
G47 (TAX) =IF(OR(SUM(G44)0,G45),(PARTS_TAX*G44)+(LABOUR_TAX *G45),"")
(PARTS_TAX is in D14) and (LABOUR_TAX is in G14)
G48 (DISCOUNT) =IF(ISNUMBER(-G46*DISCOUNT),-G46*DISCOUNT,"")
(DISCOUNT is in H14)
G49 (TOTAL) =IF(ISNUMBER(SUM(G46:G48)),SUM(G46:G48),"")
Eamon
"Mangesh Yadav" wrote in message
...
Try:
=IF(ISNUMBER(-G46*DISCOUNT),-G46*DISCOUNT,"")
and
=IF(ISNUMBER(SUM(G46:G48)),SUM(G46:G48),"")
Mangesh
"Eamon" wrote in message
...
"mangesh_yadav"
wrote in message
news:mangesh_yadav.1q1rug_1117796712.4913@excelfor um-nospam.com...
=IF(ISERR(DISCOUNT),"",-G46*DISCOUNT)
and
=IF(ISERR(DISCOUNT),"",SUM(G46:G48))
Mangesh
Thanks for your help.
I have entered your formulas as shown, but i am still getting the
#Value!
error when a new invoice is created
Eamon
Snip
|