If/Then Argument, but conditional zero

New Contributor

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!

2 Replies
best response confirmed by SMayotte (New Contributor)


Try this:

This worked perfectly! Thank you!