Excel Formula Help


Apr 10, 2017
Reaction score
Could anyone help me create a formula for an excel sheet I need to modify.

The current formula I am using for my imperial worksheet is

Up until now I have always entered D17 and F17 as imperial dimensions (hence the /144 to get square feet), now I need to enter those two items as millimeters. The only hang up is that I still need to have the output show has square feet, and the amount cannot be less than 1.5 (if it is, it has to enter as 1.5 minimum).

I am probably complicating this far more than I should be but for some reason I am stuck and can't figure this one out.

Anyone have any suggestions/solutions?



  • metric form screenshot.jpg
    metric form screenshot.jpg
    136 KB · Views: 75


Mar 25, 2003
Reaction score
Welcome to the forum! :)

I think the CONVERT formula would help you here. It works like this:

=CONVERT(number to be converted, units to be converted from, units to be converted to)

This would allow you to convert the area (width times height) from mm squared to feet squared.

This formula, combined with a MAX formula so that it can't be lower than 1.5, would do what you want. This is what I would do on your spreadsheet.


where D17 is your width and F17 is your height.

Hope this helps!

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question