Switch Function

It would be great for formulas if a Switch function was available. For example, instead of using a nested if function for rebar size, a switch function would return values much more efficiently.

Nested if function works like this:

If([Rebar Size]=4,.667,If([Rebar Size]=5,1.05,If([Rebar Size]=6,1.5,....etc)))

If the Excel Switch function was available it would be reduced to this:

Switch([Rebar Size],4,.667,5,1.05,6,1.5,7,2.04....)

Switch is much easier to evaluate. And cleaner to read when writing formulas. The value [Rebar Size] in this case can be controlled with a dropdown selection limiting the input to accepted values for the Switch Function.

Todd Kaberline zzTakeoff2h 18m

Hi David, I love it!

I am not sure if you know it, but you can also reduce the math by using a rebar product list. This way the rebar weight and diameter can be selected when you choose the size.

see below. If you need to see this in action, email me at todd@zztakeoff

I started with the nested formula and this just seemed easier.

I have the vendor and material class properties as well so I can separate the rebar in a report.

hope this helps.

You must be logged in to post replies. If you don't have an account you can signup here.