Forum Discussion
SMayotte
Sep 08, 2022Copper Contributor
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!
- Riny_van_EekelenPlatinum Contributor
- SMayotteCopper ContributorThis worked perfectly! Thank you!