Formula Calculation from multi cell to 1

can some one please

Already formulas are avilable in your attached workbook. What else you want is not understood.

i want to get these formulas from one cell can it be possible.

i have 1formula in column e and another in column g but can it be possible to write a formula in he and get he calculations for all columns

Thanks for responding to mt request. I hope you have seen my sheet.

Now what i want here is to write a formula in column H for the final result + i need to get the result in Column E & Column G from Column H. In short i want is to write a formula in Column H to calculate the result in all three columns i.e. Column E Column G & Column H.

Can it be possible.

Thanks for reply Mr. mikerickson

It is showing the -10 if the cells are zero. More over i should get the results in my above mentioned columns.

Thanks for the formula.

But i need a formula in Column H where it can calculate the calculation for column E, Column G and as well as column H.

Thanks for the reply but i am looking something like this

=IF(E5=D5/C5,G5=E3*F3-G5,"")

The above mentioned formula is not correct but the requirement which i am looking for. I am writing this formula in Column H. From Column H i am trying to calculate the other cells result and displaying the results in the columns + getting the final rest also.

I cannot delete this information because it should be their for comparizion for the users.

Sample sheet is the same.

I have written formulas in 3 difference columns but i am trying to get the results for three columns from one formula. means i don't want to write the formula in other columns but i need to display the result in their.

Yes you get right but i am not cure that i can be possible. This is what i am looking writing a formula in one cell get the result in other cells.

ooo no its cannot be done with normula formula need vba macro are you sure. But i don't want to sue macros for this. Is their any solution.

Thanks for your advice and valuable help. I am looking for formula not vba macros. Anyway thanks

I will close the topic.

I am sorry but you misunderstood me. I did not reject the formula. Your solution is perfect but my requirement is to show the results in the other 2 columns.

Thanks for your valuable and topic marked as solved now.

Thanks for your help and script. I will check it and provide you feedback. I thought if the topic is solved we cannot reply.

Mr. mikerickson your script works very well and it is to my requirement. Therefore i have attached the final format file for your reference.

Please note that you script is working for one row and 3 columns. This is the reason why i have uploaded new file.

This script should worked for all the rows i.e. from 27 to 64 (New Files).

I hope this is clear for you to help me.

Thanks for coming to help me.

I totally agree with you. But if you see the attachment file in post 29 i have other cells also which is not working. Even the file which i have attached in my first post as sample it is not working for others cells. Can you fixed it please. I will be very thankful to you.

But i have lot of rows in the same sheet what about that. How can i do the calculation. I am in the office now i will get back to you when i reach home

I mean the other column I.e. column K,column M, column n. I have to calculate those values also.

I did not understand. I am not very much known to vba macros. Can you please explain to me in details what i have to do for columns I,J,L,P,Q,S,V,W and Z. Because these are the columns which i will work. i.e. enter new amount or delete the old amount.

if i change this line it will work for all the columns which i have mentioned above.

Yes let me try and i will give you feed back

it doesn;t work for those columns

Thanks for your efforts. I really appreciate.

I have tried to change the line which you have told me but it doesn't work. Can you do me a favor please. Can you write a new script including all the following columns. Because i am not very much known about VBA Macros. I will be very thankful to you please.

C,D,F,I,J,L,P,Q,S,V,W,Z

Re-reading the macro, the body has to be adjusted to accomidate other ranges.

Hai mikerickson that's the only way cannot maintained the same format which will be easy for user to enter the values.

Can some one help to finished this up and close the topic please

Thanks mikerickson for responding to my request. Can it be done with vba macros. Your script is working very well with C, D, F Columns. I need for other columns i.e. columns I,J,L,P,Q,S,V,W and Z also can it be possible. This will be easy for users to use the file.

Hai Mr. mikerickson. Please respond to my request please.