use of ifand And function

I use this formula and i get return as False.
if i put the values in the 2 cells, i asked the formula to put 2 in one cell
=IF(AND(B1=25,C1=50),D1=2,"") in some other cell other than these cells, i get False, but whenever i change the number to any other number, i get blank as shown in if condition. How to use, if is used in 2 conditon, as in the above example. How many if and it will support,
What should i use, if suppose, i have to use the same two cells for different codes then how to use it . I will be glad to get the reply

Any chance you can put an example of the spreadsheet here

I do not have any example. I know that there are errors in my formula. I want to know how to use if and And condition in nested formula in excel 2007. And also i would like to have how many such nested functions, this conditions support. I got the error False if i put these two correctly in the cells and blank if i change . Where i am making error, i want to know

=IF(AND(B1=25,C1=50),2,0)

So you just need a small change to your current formula, change the D2=2 to 2

Thank you for the solution. But what about the number of conditions, if suppose, the same in formula to continue for 2 more conditions, how to use it. Pl

That can be done just state what they are and we will able to find your solution - I hope! LOL

I am asking if the same condition is modified,like =IF(AND(B1=36,C1=66),2,""), like that how to add, can i enter the formula =IF(AND(B1=25,C1=50),2,IF(AND(B1=36,C1=66),3,"")), like this how many times i can add

Theoretically up to 64 times (so they say - it used ti be just 7 times in older versions of Excel).

Anyway, give it a go and if you get stuck upload the file and we'll have a look then or maybe tomorrow in my case as it's evening where I live.

Cheers

Hi, can any one suggest, how to get the result of a formula in the above example,=IF(AND(B1=25,C1=50),2,IF(AND(B1=36,C1=66),3,"")), in a nested form to get the result of 2 in a cell other than the cell for eg in D1. Can i type elsewhere in the cell to get this in D1, say in M1, and 3 in some other cell, say M25
the example is =IF(AND(B1=25,C1=50),D1=2,IF(AND(B1=36,C1=66),b26=3,"")), I tried and got False or True value only in respective cells. How to overcome this problem. Can i have a nest if(and formula for this type of condition

I think this is the formula what you were looking for =IF(AND(B1=25,C1=50),2,IF(AND(B1=36,C1=66),3,"")). It is saying if cell B1 - 25 & C1 = 50, then the result will be 2, but if cell B1 = 36 and cell C1 = 66 then the result will be 3, but if cell B1 = 40 and cell C1 = say 60 then the result will be blank or as in the formula "".

Cheers,

Please see my example. I want the result in some other cell not in the present cell. If i use it i will get circular reference warning ok

I'm not with you - are you saying you want another new formula in a different cell than DI because nothing in your spreadsheet refers to any like that?? And I put the formula into D1 and go no circular warnings but my formula is different to yours,

... and please remember we are trying to help you; we don't work for you so please keep your comments civil!

A formula can only return a value to the cell you put the formula in
It cannot put a value in 'some other cell'

Hi,sir,I did not mean that way. One of my friends wish to have a formula like that. I have given him enough hints, that formula is applicable to the cell in which it is written. Otherwise, it may only end up in saying false or true. But he is insisting in that. So, I posed that query.
You have already given the solution to my first query, by removing the d1= in my formula. Thank you