I am looking for a IF formula with 3 conditions. Request for help.
Conditions:
If Cell value is less than 10000 the value should be 0
If cell value is greater than 10000 and less than 15000, the value should be 150
if the cell value is greater than 15000, the value should be 200.
I am trying the below formula but for cell value less than 10000, The value is showing as "false"
=IF(cell>10000<15000,150,IF(cell>15000,200,0))