how to use "text" in "if then" condition

  • Thread starter Thread starter If Then
  • Start date Start date
I

If Then

how can i test a condition in "text" and if the written text in a cell
(eg:A1) is correct i want the result in numeric.
eg: if A1=karur then 750

i require a assistance using a nested loop.
eg: if A1=karur and B1=vellore then 750, if A1=karur and B1= arani then 600.
(continious loop)
 
You didn't say if A1 might be anything other than Karur, so I went with what
you provided:
=IF(AND(A1="karur",B1="vellore"),750,IF(AND(A1="karur",B1="arani"),600,"not
a specific pair"))
should deal with it. You can replace "not a specific pair" with another
phrase or value such as 0.
 
Back
Top