adding two conditions in IF function

[vikash]

Hi All,

I am trying to add to if conditions, like if number say c is greater than 2000 it should return 1000 but if number c is between 1000 & 2000 result should be c-1000. Sample file is attached.

thanks in advance

regards,
vikash

 

[Nebu]

Hi:

Is this what you are looking for?

=IF(B6<1000,0,MIN(1000,B6-1000))

Thanks

 

[vikash]

Hi:

Is this what you are looking for?

=IF(B6<1000,0,MIN(1000,B6-1000))

Thanks

this will help partially because value less than 1000 should return as 0

for example
three no
936 should return as 0
1675 should return as 675
and 2675 should return as 1000

 

[Nebu]

Hi:

Did you even try the formula?

Thanks

 

[vikash]

Hi:

Did you even try the formula?

Thanks

i tried i am uploading the file with formula. b9 has value of 963 which is less than 1000 and its returning as 1000 but it should return as 0

 

[Nebu]

Not sure where you are getting 1000 for 963??, It is difficult to help if you fail to pay attention to simple details. I am getting the results exactly as what your expected results are.

 

[vikash]

View attachment 32465


Not sure where you are getting 1000 for 963??, It is difficult to help if you fail to pay attention to simple details. I am getting the results exactly as what your expected results are.

extremely sorry my mistake. thanks a lot for helping