Formula help

steve50951

I am needing to calculate total square footage, and if that total is less than 2, I need it to round up to 2. THEN multiply that # by a quantity cell

See that attached screenshot...

Upper 1 W x Upper 1 H (if total is less than 2, = 2) * 144 * QTY

Any ideas?

Thanks

Jason@JTS

Does this work?

 

=IF([Upper 1 W]@row * [Upper 1 H]@row < 2, 2 * 144 * [Upper 1 QTY]@row, [Upper 1 W]@row * [Upper 1 H]@row * 144 * [Upper 1 QTY]@row)

Paul Newcome

You could also use

 

=IF([Upper 1 W]@row * [Upper 1 H]@row < 2, 2, [Upper 1 W]@row * [Upper 1 H]@row) * 144 * [Upper 1 QTY]@row

 

It will accomplish the same thing as Jason's formula. It's just a little more condensed is all.

steve50951

Paul, this worked perfectly. thanks so much

SGF