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.
message edited by mmcconaghy
Thanks Mike!! Worked great!! Will go to Office Software forum for other questions. Thanks again.
Ad Choices