Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If then statements
I have what to me seems like a difficult task. I am creating a workbook that
will convert the number of 3 foot panels needed on the gable end of a building when given roof pitch, wall height, width and length. I am able to do everything but this; on the width of the builoding it will increase the panels in length every three feet. I want excell to calculate the # of panels needed and at what length. If you have any Ideas please email me at . |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If then statements
David --
If the width of the building in feet is in A1, then try: =INT(A1/3)+1 unless I'm missing something from your description. HTH "David Bryant" wrote: I have what to me seems like a difficult task. I am creating a workbook that will convert the number of 3 foot panels needed on the gable end of a building when given roof pitch, wall height, width and length. I am able to do everything but this; on the width of the builoding it will increase the panels in length every three feet. I want excell to calculate the # of panels needed and at what length. If you have any Ideas please email me at . |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If then statements
Not so much. I want it to return the number of panels needed at a certain
length. Like on an amortization schedule it will return 12 payments @ 30 dollars. I want it to read; 12 at 3 10 at 4 ect. ect. "pdberger" wrote: David -- If the width of the building in feet is in A1, then try: =INT(A1/3)+1 unless I'm missing something from your description. HTH "David Bryant" wrote: I have what to me seems like a difficult task. I am creating a workbook that will convert the number of 3 foot panels needed on the gable end of a building when given roof pitch, wall height, width and length. I am able to do everything but this; on the width of the builoding it will increase the panels in length every three feet. I want excell to calculate the # of panels needed and at what length. If you have any Ideas please email me at . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If then statements
David --
Hokay. Now that I understand it, I have a better approach anyway: A B 1 # 2 3 =ROUNDUP($B$1/A2,0) 3 4 copy that down 4 6 5 8 Should work fine. HTH "David Bryant" wrote: Not so much. I want it to return the number of panels needed at a certain length. Like on an amortization schedule it will return 12 payments @ 30 dollars. I want it to read; 12 at 3 10 at 4 ect. ect. "pdberger" wrote: David -- If the width of the building in feet is in A1, then try: =INT(A1/3)+1 unless I'm missing something from your description. HTH "David Bryant" wrote: I have what to me seems like a difficult task. I am creating a workbook that will convert the number of 3 foot panels needed on the gable end of a building when given roof pitch, wall height, width and length. I am able to do everything but this; on the width of the builoding it will increase the panels in length every three feet. I want excell to calculate the # of panels needed and at what length. If you have any Ideas please email me at . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel MS Query multiple select statements | Excel Discussion (Misc queries) | |||
Creating my own user defined function help statements | Excel Worksheet Functions | |||
UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
Linking two IF statements together | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions |