Forum Discussion

SMayotte's avatar
SMayotte
Copper Contributor
Sep 08, 2022
Solved

If/Then Argument, but conditional zero

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!

Resources