Sep 08 2022 04:38 AM - edited Sep 08 2022 04:39 AM
Good morning, all
I'm struggling with a formula that I am using to calculate square footage, but lists a minimum sq footage of '5'.
My current Formula states =IF(L12<5,"5",L12*1).
This works wonderfully, but it's also equating lines with a value of zero as '5'. Try as I might, I can't figure out how to allow '0' to show its true value on its own. Any assistance would be greatly appreciated. Thanks!
Sep 08 2022 04:43 AM
SolutionSep 08 2022 04:43 AM
Solution