I am using a formula to figure square footage on a cabinet door: =SUM(A1*B1)/144

11 x 23 1/2 / 144 = 1.80 sq ft (This number needs to change to 2. 2 square feet being minimum per cabinet door.

15 1/4 x 36 1/2 / 144 = 3.87 sq ft (This number needs to remain as it is since it is = or over 2 sq ft.

If that square ft number is less than or = to 2 I want that number to be 2. If it is 2 or over it needs to be whatever the number calculates out to.

Any help would be greatly appreciated

Try this: =IF(SUM(A1*B1)/144<=2,2,SUM(A1*B1)/144)

Should get you want your looking for.

And, in the future, Excel questions are best asked in the Office Software forum.

MIKE

message edited by mmcconaghy

Thanks Mike!! Worked great!! Will go to Office Software forum for other questions. Thanks again.

Ask Your Question

Weekly Poll