Can anyone solve my excel problem?

[aliasger.q]

Hello............

I am working on one excel file for tax calculation purpose but i stuck on one problem.

In details/Example

i have a 3 column like a1 has percentage column, b1 has amount column and last/c1 column show total amount of consignment which we received, here what i want to do if some one put percentage in a1 so base on c1 directly it should calculate amount of percentage and put in b1, like vice versa if i put amount in b1 so should calculate percentage based on c1 and put in a1 field.


please help me in terms of formula or macros anything.

thanks

 

[NARAYANK991]

Hi ,


Does it mean that given two out of the three fields , the third should be calculated and inserted in the appropriate cell ?


Let us consider a new row of data entry , say row 4 ; suppose two items of data are entered in A4 and B4 ; then C4 has to be calculated.


Narayan

 

[SirJB7]

Hi, alisger.q!


Perhaps you want to read the three green sticky posts at this forums main page so as to know the guidelines that will lead to know how this community operates (introducing yourself, posting files, netiquette rules, and so on).


And about your question, you can do this:

- let your A, B & C columns as they are

- add a D column titled "Actual %"

- add an E column titled "Actual amount"

- supposing your data starts from row 2, in D2 type:

=SI(ESBLANCO(A2);B2/C2;A2) -----> in english: =IF(ISBLANK(A2),B2/C2,A2)

- and in E2 type:

=SI(ESBLANCO(B2);A2*C2;B2) -----> in english: =IF(ISBLANK(B2),A2*C2,B2)

- copy D2:E2 down as needed


Hope it helps you.


Regards!

 

[aliasger.q]

Thanks everyone for important and valueable comments.


I have used macros for input box of both the columns.

and its working very fine and good so now its fullfill my requirement now.


thanks again.