If Function (multiple criteria)

[farzadtaheri]

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 · Accepted solution]

@farzadtaheri 

In L4:

=MAX(MIN(K4,1500),0)

Fill down.

[#3]

Thank you!