| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help fast Please Pulling the gray hair out!!!!!!
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help fast Please Pulling the gray hair out!!!!!!
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help fast Please Pulling the gray hair out!!!!!!
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help fast Please Pulling the gray hair out!!!!!!
Download a file with calculations from
http://wikisend.com/download/551354/Galss Calculation.xls and post your comments "Mike Stewart" wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help fast Please Pulling the gray hair out!!!!!!
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help fast Please Pulling the gray hair out!!!!!!
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel formula i'm pulling my hair out | Excel Discussion (Misc queries) | |||
| Pulling my hair out here | Excel Worksheet Functions | |||
| Pulling my hair out, need some help building a formula | Excel Worksheet Functions | |||
| combo box problem I am pulling my hair out about!!!! | Excel Worksheet Functions | |||
| Pulling hair out with VLOOKUP | Excel Worksheet Functions | |||
Linear Mode
