Forum Discussion
farzadtaheri
Jun 21, 2021Copper Contributor
If Function (multiple criteria)
I need a formula that would give me these results:
If K6 is more than $1,500, then enter $1,500 into L6
If K6 is between 0 and $1,500, then enter the value from K6 into L6
If. K6 is below 0, then enter 0 into L6
2 Replies
- farzadtaheriCopper ContributorThank you!