Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional if -ajit
I have entered 2 formulae with if function in cell a2 and a3. I want excel to
execute formula in a2 if condition 1 satisfies else execute formula in a1. can I do so? how? thanx ajit -- Knowldege is Power |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional if -ajit
In A1: =IF(B1=1,"B1 is 1","")
In A2, =IF(B1=2,"B1 is 2","") best I can do with the limited info you gave -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Ajit Munj" wrote in message ... I have entered 2 formulae with if function in cell a2 and a3. I want excel to execute formula in a2 if condition 1 satisfies else execute formula in a1. can I do so? how? thanx ajit -- Knowldege is Power |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional if -ajit
sorry, I donot understand.
In cell b2, I have to enter M for male and F for Female In cell b3, I have entered formula with IF function for income tax calculation for Male and In cell b4, I have entered formula with IF function for income tax calculation for Female. Now in cell b5, I want to execute formula in b3 for male or b4 for female. How can I achieve this? (In b5 =if(b2=M, execute b3 else b4) -- Knowldege is Power "Bernard Liengme" wrote: In A1: =IF(B1=1,"B1 is 1","") In A2, =IF(B1=2,"B1 is 2","") best I can do with the limited info you gave -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Ajit Munj" wrote in message ... I have entered 2 formulae with if function in cell a2 and a3. I want excel to execute formula in a2 if condition 1 satisfies else execute formula in a1. can I do so? how? thanx ajit -- Knowldege is Power |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional if -ajit
Hi Ajit
instead of having your 3 cells with formulas, you could put them in 1: in B3: =if(B2="M", "yourcalcM", "yourcalcF") where yourcalcM is your formula in cell b3 now and yourcalcF is your formula in cell b4. or else, if you want to keep your B3 and B4, you could do this in B5: =if(B2="M",B3,B4) hth Carlo PS: Your signature has a typo! it's "Knowledge" not "Knowldege" On Dec 5, 3:57 pm, Ajit Munj wrote: sorry, I donot understand. In cell b2, I have to enter M for male and F for Female In cell b3, I have entered formula with IF function for income tax calculation for Male and In cell b4, I have entered formula with IF function for income tax calculation for Female. Now in cell b5, I want to execute formula in b3 for male or b4 for female. How can I achieve this? (In b5 =if(b2=M, execute b3 else b4) -- Knowldege is Power "Bernard Liengme" wrote: In A1: =IF(B1=1,"B1 is 1","") In A2, =IF(B1=2,"B1 is 2","") best I can do with the limited info you gave -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Ajit Munj" wrote in message ... I have entered 2 formulae with if function in cell a2 and a3. I want excel to execute formula in a2 if condition 1 satisfies else execute formula in a1. can I do so? how? thanx ajit -- Knowldege is Power- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Conditional formats and insert comment - ajit | Excel Discussion (Misc queries) | |||
scrolling up & down - ajit | Excel Discussion (Misc queries) | |||
count conditional days - ajit | Excel Discussion (Misc queries) | |||
conditional sum - Ajit | Excel Discussion (Misc queries) | |||
Calendar - Ajit | Excel Discussion (Misc queries) |