Correction require

[aligahk06]

Dear All,

Can i make a condition for range of cells in and function, Correction require in below function
=IF(AND(B6:B525>=15000,B6:B525<=16000),"SERVICING","Change Oil after every 2500KM")

Rgds,
ak

 

[Peter_SSs]

It isn't clear what you are trying to achieve. It looks to me like you might need to be calculating for every row individually. So, in row 6, copied down

=IF(AND(B6>=15000,B6<=16000),"SERVICING","Change Oil after every 2500KM")

If that isn't waht you want, you might need to post 5-10 rows of dummy sample data and the expected results and explain what you want in relation to that sample data.

 

[aligahk06]

It isn't clear what you are trying to achieve. It looks to me like you might need to be calculating for every row individually. So, in row 6, copied down

=IF(AND(B6>=15000,B6<=16000),"SERVICING","Change Oil after every 2500KM")

If that isn't waht you want, you might need to post 5-10 rows of dummy sample data and the expected results and explain what you want in relation to that sample data.

I have CELL B6:B520 which contains numerical value . if any cell value become >=15000 or <=15500 and again >=20000 or <=20500 then cell H50 gives a alert SERVICING or pop up a MESSAGE FOR SERVICING.

 

[Peter_SSs]

.. and again >=20000 or <=20500 ...

What do you mean by that part (that wasn't mentioned before)?

 

[aligahk06]

What do you mean by that part (that wasn't mentioned before)?

One more condition included.

 

[Peter_SSs]

One more condition included.

It isn't clear to me. A cell cannot be between 15000 & and 15500 and also between 20000 and 20500. Could you make up a small set of dummy data, say 8-10 rows and post that together with the expected result(s) and explanation in relation to that data?

 

[aligahk06]

Cell Value
B5 :7779
B6 :8642
B7 :9180
B8 :9785
B9 :10470
B10 :11130
.........
..........

In a single any cell ( for ex H52 CELL ) I need a formula that (B5:B400 >=15000 AND B5:B400 <=15500) then display servicing else nothing..
Thanks....

 

[Peter_SSs]

Cell Value
B5 :7779
B6 :8642
B7 :9180
B8 :9785
B9 :10470
B10 :11130
.........
..........

In a single any cell ( for ex H52 CELL ) I need a formula that (B5:B400 >=15000 AND B5:B400 <=15500) then display servicing else nothing..
Thanks....

So, the rows have changed (now starting at 5 & stopping at 400) and the extra condition (between 20000 & 20500) has disappeared & 'Change oil" has disappeared. Bit hard to keep up with the changes.

=IF(COUNTIFS(B5:B400,">=15000",B5:B400,"<=15500"),"SERVICING","")