Thread: conditional value required on basis of column a
View Single Post
  #3   Report Post  
Aladin Akyurek
 
Posts: n/a
Default
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,"")
Reply With QuoteReply With Quote