conditional value required on basis of column a
if cell value of column A1 is between 3000 - 5000 then apply the cell value of column B1 =90 -- ilyaskazi ------------------------------------------------------------------------ ilyaskazi's Profile: http://www.excelforum.com/member.php...o&userid=23969 View this thread: http://www.excelforum.com/showthread...hreadid=376227 |
In B1 enter: =IF(AND(A1=3000,A1<-5000),90,"") If between 3000 and 5000, then b1 = 90, otherwise it would be blank. Mangesh -- mangesh_yadav ------------------------------------------------------------------------ mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470 View this thread: http://www.excelforum.com/showthread...hreadid=376227 |
ilyaskazi wrote:
if cell value of column A1 is between 3000 - 5000 then apply the cell value of column B1 =90 Do you mean: =IF(AND(A1=3000,A1<=5000),B1,"") |
Thanku mangesh, it is working perfect. regards, ilyaskazi -- ilyaskazi ------------------------------------------------------------------------ ilyaskazi's Profile: http://www.excelforum.com/member.php...o&userid=23969 View this thread: http://www.excelforum.com/showthread...hreadid=376227 |
Put in B1: =IF(AND(A1=3000,A1<=5000),90,"")
Copy down Note that the above will return blanks: "" as the values_if_false (you didn't specify this) Adapt to suit .. -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "ilyaskazi" wrote in message ... if cell value of column A1 is between 3000 - 5000 then apply the cell value of column B1 =90 -- ilyaskazi ------------------------------------------------------------------------ ilyaskazi's Profile: http://www.excelforum.com/member.php...o&userid=23969 View this thread: http://www.excelforum.com/showthread...hreadid=376227 |
All times are GMT +1. The time now is 09:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com