Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
One for the Master Minds out there
This is something that I have never had to do before so I dont even know
where to start. My spreadsheet calculates linear feet of reinfircing steel based on criteria that I enter. I have the formulas working thatnks to the great help of others today. Now I have a series of linear feet that I have to add to one total. However if the length of reinforcing steel is greater than 20 feet you have to splice it which adds about 4 feet to the bar lenght, but it is for EVERY 20 feet incrment. So here is what I need. If A1<20 then formula a If A120 then formula+4 (But for every 20 foot increment) Is this possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
One for the Master Minds out there
Try this:
=IF(A1<20,Formula_A,Formula_A+4*(A1/20)) Or, if you only want to calculate "full" 20 ft lengths: =IF(A1<20,Formula_A,Formula_A+4*INT(A1/20)) -- Biff Microsoft Excel MVP "Neil M" wrote in message ... This is something that I have never had to do before so I dont even know where to start. My spreadsheet calculates linear feet of reinfircing steel based on criteria that I enter. I have the formulas working thatnks to the great help of others today. Now I have a series of linear feet that I have to add to one total. However if the length of reinforcing steel is greater than 20 feet you have to splice it which adds about 4 feet to the bar lenght, but it is for EVERY 20 feet incrment. So here is what I need. If A1<20 then formula a If A120 then formula+4 (But for every 20 foot increment) Is this possible? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
One for the Master Minds out there
If you total length is in A1, then the number of twenty foot sections is:
=INT(A1/20) or the length with the splices is: =A1+4*INT(A1/20) for if A1 contained 234 then the formula gives: 278 because 11 splices are needed. -- Gary''s Student - gsnu200793 "Neil M" wrote: This is something that I have never had to do before so I dont even know where to start. My spreadsheet calculates linear feet of reinfircing steel based on criteria that I enter. I have the formulas working thatnks to the great help of others today. Now I have a series of linear feet that I have to add to one total. However if the length of reinforcing steel is greater than 20 feet you have to splice it which adds about 4 feet to the bar lenght, but it is for EVERY 20 feet incrment. So here is what I need. If A1<20 then formula a If A120 then formula+4 (But for every 20 foot increment) Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Master List | Excel Discussion (Misc queries) | |||
Master Sheet | Excel Discussion (Misc queries) | |||
Master & Sub Worksheets? | New Users to Excel | |||
using a master reference | Excel Worksheet Functions | |||
FORMULA USING MASTER QTY | Excel Discussion (Misc queries) |