Solved How to do a SUM & IF formula in Excel

October 9, 2014 at 13:28:14
Specs: Windows 8
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


See More: How to do a SUM & IF formula in Excel

Report •

#1
October 9, 2014 at 13:53:44
✔ Best Answer
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

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#2
October 9, 2014 at 14:13:44
Thanks Mike!! Worked great!! Will go to Office Software forum for other questions.

Thanks again.


Report •
Related Solutions


Ask Question