Formula help: If([Wall Height]==9, [Length]\1, 0)

Completed

Need some help with the IF formula. I am trying to make one segment takeoff (Length with Wall Height) for stud walls that will select stud item based on Wall Height.

Looking at a takeoff where I set Wall Height to 9’ for example:

[Wall Height]==9 returns [True] but when I try to put that in an IF statement, it gives an error.

What do I need to do differently?

If([Wall Height]==9, [Length]\1, 0)

Heber Allred zzTakeoff41d 1h

Hi Scott! For now, the "if" must be lower case (case sensitive). We'll work to make it case insensitive in the future. Also I notice a "\1" in there, which would also cause an error:

Here is a fixed version:

if([Wall Height]==9, [Length], 0)

Scott Babin 41d 1h

Thanks!

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