SOLVED

If/Then Argument, but conditional zero

Copper 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 (Copper Contributor)
Solution

@SMayotte

Try this:

=IF(AND(L12<5,L12>0),5,L12*1)
This worked perfectly! Thank you!
1 best response

Accepted Solutions
best response confirmed by SMayotte (Copper Contributor)
Solution

@SMayotte

Try this:

=IF(AND(L12<5,L12>0),5,L12*1)

View solution in original post