Hi ,
I have done one calculation as shown in image below
i want to make excel so that i can get answer directly
after i put 4 numbers
in one excel **** both way i want as show in image
straight and cross calculation
can anyone do it ?
and 498 number is in between will be same always
offcourse it will need alot of brain here
and i am not having it so i want you guys to help me
The forum is not for making excel files for you, only to help you with (Excel)problem(s).
If you make an file and tells us where you have problems, we will try to help you.
In that case you can better add an excel file without confidentional information.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
i have problem that i dont know excel and thats why i am on this site so people can help me
i have done calculation with my hands and it take alot of time and thats why i am here to make my work little easy if anyone can make excel sheet for me it will be helpful offcourse my calculations are hard to understand and maybe nobody can make this kind of excel but guys you can try it will be helpful for me
Why don't you try it yourself.
You know what you want to achieve.
In your .jpg I can't see what you're up to.
How can I make an file for you if I don't know what you'r up to?
Have said that, i won't make it for you anyway.
I can, and I will help you with the formula you need (if i be able).
i will explain how to calculate it .
117 - 247 789 - 349 | 117 \ / 247 789 \ / 349
570 - 469 129 - 288 | 570 / \ 469 129 / \ 288
i need excel sheet in that if i put this numbers ( numbers can be changed )
so i should get answer as i shown in that image
( 498 number will always remain same )
( 976 number will always remain same )
we have to place this all numbers in same format in excel as in image
maybe you know formula for that ?
then when it get added it should not take hands on number
for eg : 5 + 5 = 10 so we will just take only 0
i know its very hard work
thats why i am here for help
please if anyone can do it for me ???
Last edited by samj221; 09-01-2012 at 06:40 AM.
You get better help if you post an Excel-file (example of your workbook), without confidential information.
Make sure the workbook demonstrates your desired results if possible, or just highlight the cells you're trying to fix.
Use BEFORE/AFTER sheets if that helps make it clearer.
ok you wanted i should send excel i have made excel
and put all numbers on it
can you please add formula on it now
i am waiting
row 14 can be done with the formula in row 18 (yellow cell).
See the attachment.
for the other item i would have to take a look.
And for the other (1 figure) this wil work.
If you understand the formula, you can use it for the second and third option.
Do you have questions on this item, just ask.
Please reply, if this is what you're up to.
Originally Posted by oeldere
Hi , yes you did good work , i think you can make this for me wow
but i want that i should just put the main 4 numbers in cell upside that i have made in red
and i should get answers directly for all 4 sums
i should get all 4 answers of my sum ( cell 14 ) with just 4 number that are in red
i have attached the excel check it
I don't understand what you try to achieve.
What is cell 14.
Please add the wanted result in the sheet and post it again.
ok sir i will explain in details
this are 4 sums , i want excel sheet to be prepared in this way
that if i put the numbers in red color number place i should get answer of this sums directly
A14 is total answer of all sums ( solved answer )
you made formula for only 1 sum i want all other 3 sum answer also
i will just put numbers of my choice in that place where i have made number in red
and i should get all 4 sums answer directly
If you change the input in table 3 and table 4 you get the result you want.
See the example.
Pleases reply, if this is what you want!
Last edited by oeldere; 09-01-2012 at 01:54 PM.
And now you only have to input the data in the pink cells.
Pink cells (a1 / a2 / c1 / c2)
See the attachment.
i don't understand, why you look at the result,
and don't reply if the answer is what you want!
This is what i wanted and you did it good
you made it as i wanted thankyou
i have to further continue this sum with the answer i got
Last edited by samj221; 09-02-2012 at 10:38 AM.
So to continue.
Which addional questions you have?
I have attached my old excel with further solution on it
the first part you made with forumla was perfect
we got all answers correct as we wanted
now this second parts question is our first part answer
that means row 26 IS our first sum answer
and second sum Question
please see the image you will get idea how i have solved the sum
I just want you put formula so that i get answer on row 42 and 43
i will try my best to explain its really hard but i am sure you get the idea
that i want
waiting for your help
Please also add the file with the comments in it.
I don't understand how it is calculated.
Please also explain why the answer (case 2) should be:
6 2 0 2 8 5 5
instead of
4 2 0 2 8 5 5
I have commented and explain in details in this attached excel you will understand
now why my answer is coming in 6 2 0 2 8 5 5
See if this is what you're up to.
Please do reply if it is what you want
or reply if this is not what you want
I cannot open this excel in my computer
file format .xls
i can open in my computer .xlsx
i cannot open
See the .xls file
answer in E43 should be 8
answer in U43 should be 5 ( maybe you added 1 double time )
and F34 should add with H36 automatically for eg: 7+9=16 so only 6 should come in cell F36
and same way F34 should add with H38 automatically for eg: 7+7=14 so only 4 should come in cell F38
and same way F34 should add with H40 automatically for eg: 7+6=13 so only 3 should come in cell F40
This way we should add formula in all 4 sum
numbers in red color should only be added with ( 9,7,6 permanent number )
and i want that if i just put numbers of row 34
so i should get all answer directly that means row 43
please see my new excel i have attached and edited it little
I changed the file, based on your text.
See if this is what you want.
Please reply on the file in #26.
You been, not long ago, on the forum and don't reply, why not?
Please do reply if it is what you want
or reply if this is not what you want
Re: Need excel **** with this kind of calculation as in shown image
wow , it worked there was little cell mistake in 2 place in formula i have tried to fix it and its working perfect now wow good
but now there is only one thing more i want with this excel is that
row 26 answer should automatically copied to row 34
so that directly it get calculate everything till the end from start to end
hope you understand what i want to say
I have attached the excel please check it
it worked there was little cell mistake in 2 place in formula i have tried to fix it and its working perfect now wow good
For i change it, what did you changed in the file?
in formula there was just little cell numbers was misplaced
instead of 38 you used 40 somewhere
but you did it perfectly
very thanks to you
i thought it will never happen
but you done so good i am thankful to you
and now this is remaining
row 26 answer should automatically copied to row 34
so that directly it get calculate everything till the end from start to end
i think it will be easy for you
See the file.
And don't forget to reply.
you have put wrong permanent number ( 498 you should put )
pls edit that and send me again
and i will check it again
I don't see it.
So You put the file up here, and I will take a look at it.
In which cell it is not right?
Wow , you have done it good
there was little cell mistake in 2 or 3 places
but it was little mistake
you are genius
I am still cross checking this excel now
with sum i have solved few months before
I am sure all answer will come now correct if yes so i will ask for your help again to solve further this same sum
still this sum is not completed we just done only 1 page of the sum till now
hope this is interesting for you also
I have attached the edited excel you can also check it
you are best
thanks alot
Please tell me which cells do you changed?
I don't mind you changing the file, but i think there is no need for it!!!
In that case i do mind, because you get an wrong model !!
So please respond, which cells you have changed in the last file. (project(samj221)(oeldere3).xls
I will have to download now your previous file again
and check that mistake you want me to do it ???
it was not a big mistake just 2 , 3 places i changed little cell numbers and all is working properly
Yes, i want you to do that.
I explained why in #35.
In V23 you put this formula
=IF((V$17+X23)<10,V$17+X21,RIGHT(V$17+X23,1)*1)
and i changed it to
=IF((V$17+X23)<10,V$17+X23,RIGHT(V$17+X23,1)*1)
-----------------------------------------------------------------
In V21 you put this formula
=IF((V$17+X21)<10,V$17+X19,RIGHT(V$17+X21,1)*1)
and i changed it to
=IF((V$17+X21)<10,V$17+X21,RIGHT(V$17+X21,1)*1)
---------------------------------------------------------------
In F21 you put this formula
=IF((F$17+H21)<10,F$17+H19,RIGHT(F$17+H21,1)*1)
and i changed it to
=IF((F$17+H21)<10,F$17+H21,RIGHT(F$17+H21,1)*1)
---------------------------------------------------------------
In F23 you put this formula
=IF((F$17+H23)<10,F$17+H21,RIGHT(F$17+H23,1)*1)
and i changed it to
=IF((F$17+H23)<10,F$17+H23,RIGHT(F$17+H23,1)*1)
You could change formulas like
=IF((V$17+X23)<10,V$17+X23,RIGHT(V$17+X23,1)*1)
to
=MOD(V$17+X23, 10)
Entia non sunt multiplicanda sine necessitate
@SHG
That is a very good suggestion.
@samj221
The corrections you mentioned, are not in the last file. (project(samj221)(oeldere3).xls
Those formula's (in the last file) are OK.
For future use please reply in which file you find wrong formula.
Have said that, what are the new questions?
Please explain well !!
Re: Need excel **** with this kind of calculation as in shown image
yes sure from now on if i change anything i will tell you that thing
and new question is continuation of same sum
i have attached excel, in that i have wrote cell numbers and comments
that we have to add and that we should get answer in which cell
Last edited by Cutter; 09-04-2012 at 10:54 AM. Reason: Removed whole post quote
Please test with other options.
See the file.
Please reply if this is what you want,
Please reply if this is not what you want.
Re: Need excel **** with this kind of calculation as in shown image
i am getting final answer wrong when i put change my sum with different number
i changed 117 with 266
247 with 279
570 with 250
469 with 149
and other side i changed
789 with 234
349 with 489
129 with 467
288 with 337
so i should get the final answer 23657312 and 23157262
Last edited by Cutter; 09-04-2012 at 10:54 AM. Reason: Removed whole post quote
Thanks for the reply.
I will look at it.
try this please.
I'm specaly interested when the value becomes 10 in the last row.
please reply your comments.
wow , now its working
perfectly done by you thanks
but still i want to check it with more different numbers
still there is more further this sum will go i will post tomorrow further part
thanks alot
Last edited by Cutter; 09-04-2012 at 10:55 AM. Reason: Removed whole post quote
Re: Need excel help with this kind of calculation as in shown image
here it is further sum i have attached the file and wrote all in details in excel
this is also same way all answer should get copied automatically in chain way
in next sum so we get answer directly
please reply soon
I have tried putting different number to check our excel , but i am getting wrong answer when i have put this number i have commented on the wrong answer first please check that
I will check your commets of #49, but maybe it is not today.
I'm interested where you use this file for.
What is the purpose (goal) of this file.
I work in one company as a mathematics problem solving person
they give me this numbers and i have to solve all till the end ( number change in every sum )
i get 15 sum in 1 month and i have to work hard on it , if 1 number goes wrong whole my 8 hours get wasted
so i am making this excel so nothing should get wrong and i should do my work in some minutes instead of everyday 8 hours
and till now we are making 1st page ya its a really hard maths sum
mostly addition part but its very long process
and i dont have any short cut
hope you got my point
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks