Cutting List Attempt

[James Russell]

I was attempting to make a cutting list by doing a lookup on my extrusions with Type is extrude.

All is well and good and I can output the values for =height =width and depth by another formula mentioned in the forum, =volume/(height*width), which works effectively.

I am now attempting something much more intense and I hope someone can tell me why it will not work. I want to return the highest value from the height, width or depth as a stand alone formula.

What I have come up with is this:

=IF(WIDTH>HEIGHT, WIDTH, IF(HEIGHT>VOLUME/(WIDTH*HEIGHT)), HEIGHT, VOLUME/(WIDTH*HEIGHT))

The first if statement alone works fine if it is =IF(WIDTH>HEIGHT, WIDTH, HEIGHT) but as soon as the second IF statement is added it will not work, is it something to do with my syntax or can two ifs not be used?

Cheers,

James

[Pat Stanford]

I think you have your parentheses in the wrong place. Try this version:

=IF(WIDTH>HEIGHT, WIDTH, IF(HEIGHT>VOLUME/(WIDTH*HEIGHT), HEIGHT, VOLUME/(WIDTH*HEIGHT)))

Note that one paren was moved to the end instead of after the first V/(W*H)

[James Russell]

Thanks Pat, it's always just one little sucker who has to be in the wrong place.

Cheers.