View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default 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