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

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)
 
J

JLatham

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF(AND condition 1
Block cell if specific condition exists 7
Multiple if condition formula required 4
If........then...... 2
formulas, if/then 1
multiple if condition 6
nested IF without repeating the condition to be tested 6
How to assign nothing into a cell under if condition? 7

Top