Format?

drvajeep

New Member
Joined
Jun 19, 2012
Messages
3
How would I get excel to figure the Hardware required for the number of treads (4 per tread) in the hardware box, with hardware listed, 3/8" bolts, nuts & washers. I need this box to reamin N/A if no hardware is required.
TREAD SHEET
GRATING TYPE:1 1/4" x 3/16" PLAIN
NOSING TYPE:CHECKER PLATE
FINISH:GALVANIZED
HARDWARE:N.A.
NO. OF TREAD SIZE"A" DIM.HOLETRD. WT.REFERENCE DRAWING
TREADS DIAMETER
1001'-0 1/8" X 3'-0" 31
1010 15/16" X 2'-6" 28
110PCS. TOTALTOTAL WT. :3380

<colgroup><col style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;" width="80"> <col style="width: 135pt; mso-width-source: userset; mso-width-alt: 6582;" width="180"> <col style="width: 38pt; mso-width-source: userset; mso-width-alt: 1865;" width="51"> <col style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;" width="72"> <col style="width: 45pt; mso-width-source: userset; mso-width-alt: 2194;" width="60"> <col style="width: 139pt; mso-width-source: userset; mso-width-alt: 6765;" width="185"> <tbody>
</tbody>
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Hello,

If I am not mistaken, at the bottom to the left of "PCS. TOTAL" is the total number of treads. If this is true, then in the cell next to Hardware you should try this:
=IF(Total PCS. > 0, Total PCS. *4, "N.A.")

Place that formula in the cell you currently show as "N.A."

Replace "Total PCS." in the formula with the cell reference you currently show 110 in. (eg. A1, C17, B34).

Hope thats what your looking for.

Trey
 
Upvote 0
Thanks TKB that worked, it displayed the number in the hardware box, is there a way for me to add text before or after the number I would like it to read 1 1/4" x 3/8" Bolts, Nuts & Washers Req'd. 440, and display N.A. if no hardware is required.
Would it be easier to have the hardware note or N.A. in the cell, and have the total required in the cell to the right.
 
Upvote 0
Hey drvajeep,

try using the & function. so the formula would look like this:

=IF(Total PCS. > 0, "Text Before" & (Total PCS. *4) & "Text After", "N.A.")

That should work (but i havent had time to check it out myself).
 
Upvote 0

Forum statistics

Threads
1,213,521
Messages
6,114,109
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top