Forum Discussion

farzadtaheri's avatar
farzadtaheri
Copper Contributor
Jun 21, 2021
Solved

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

 

Resources