Formula help

steve50951 · 02/18/19

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

Screen Shot 2019-02-18 at 10.54.30 AM.png

Jason@JTS · 02/18/19

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 · 02/19/19

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 · 02/19/19

Paul, this worked perfectly. thanks so much

SGF

Comments