Excel 2007 : Nesting the formula

Hi,

Please help me with the follwing formula for Taxation puropose.

The two formula to be compliled together for the gender selected

Regards

Shaj

If select male, the formula corresponding to the male should return the result and if its female, it should return the female result. I mean the two formula clubbed together and when the *** column updated(male or female) automatically it should return the result of the gender tax corresponding to that particular employ

Which formula? You need to explain your problem, it's not clear from the example & some members cannot download examples

Do you mean you want to combine the formula like this?

Please Login or Register  to view this content.

Dear Moderator,

Thanks for your help. Its working for me.
you guys are really marvellous


Regards,

Shaj

Please Login or Register  to view this content.