Need help fast Please Pulling the gray hair out!!!!!!
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
|