Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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,"") |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting applicable to entire column | Excel Worksheet Functions | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
conditional formatting based on column | Excel Discussion (Misc queries) |