Excel formula on IF
Posted
by
Ashvin
on Super User
See other posts from Super User
or by Ashvin
Published on 2014-06-11T07:03:08Z
Indexed on
2014/06/11
9:29 UTC
Read the original article
Hit count: 144
microsoft-excel
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))
© Super User or respective owner
