conditional if -ajit

A

Ajit Munj

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
 
B

Bernard Liengme

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
 
A

Ajit Munj

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

carlo

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"
 

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

Top