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

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

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

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 -