Glad I could help. Thanks for the feedback.

Fred.

"Mike Stewart" wrote in message
...
Thanks Fred
It worked perfect
Out of jam now!!!!!!!!!!!

"Fred Smith" wrote:

The help you get can be only as good as the problem is explained. The
better
you explain the problem, the better help you will get. A good start in an
explanation is to show what formulas you have used, what results you got,
and what you want instead. Examples are also very helpful. From your
description, I'd try in G1:

=a1*b1*c1/144*e1*(1+f1)

This assumes the value in e1 is cost per sq ft.

Regards,
Fred.
"Mike Stewart" wrote in message
...
A1quanity B1Width XC1Height /144=D1sqft XE1cost +F1tax =G1total

Glass size is not constent as pictures are not the same.

Its hard to explain when I'm new
Mike



"Sheeloo" wrote:

Pl. don't tear them out... you get them after many years of hard
living
:-)

Did you mean B1 instead of A1 at the end of the sentence;
I need A1 to multiply the cost in E1 if more than1 piece is
indacated
in A1

You can not use a formula in A1 to refer to the value in A1

Try this in F1 to get the multiplication of pieces in A1 with Cost in
E1

=IF(A11, A1*E1,"")

You can copy this down for other rows.
"Mike Stewart" wrote:

I have made a glass calc sheet, with that said here is the problem.
I need to be able to input in A1 the number of pieces B1 is the
width
and C1
is the height D1 is the sq ft E1 is the cost.
I need A1 to multiply the cost in E1 if more than1 piece is
indacated
in A1

Thanks
Mike