Feb 27 2020 10:47 AM
Feb 27 2020 01:16 PM
Hello @fuelbreak,
In cells A3, B3, C3, respectively, that could be:
x<=50000
=IF(A1<=50000,A1,50000)
50000<x<=200000
=IF(A1>200000,150000,IF(AND(A1>50000,A1<=200000),A1-50000,0))
x>200000
=IF(A1>200000,A1-200000,0)