Hi all, need help.
i have a specific number that i want to divide into a range of numbers eg:
A2 is 98 B2 is 456,560
B3 is 562,160
B4 is 625,625
B5 is 458,560
B6 is 758,450
So i need the correct formula that will divide 98 into any B cell that i click onto, to give me the exact amount.
Thanks i hope someone can help.
Not clear for me. But may be you are interested in how many numbers are in column B and then divide your A2 by this count. to do so you could use
Formula:
Please Login or Register to view this content.
Best Regards,
Kaper
Or may be you want to divide it proportionally - then in c2 use:
Formula:Please Login or Register to view this content.
and copy it down
Hi Kaper, thanks for reply, i copied and paste my spreadsheet, not sure if that will help.
So what i want to do is be able to click any of the total cells and below where i have the power amount, divide that into the total so it will give me the exact troop amount i need to send to clear that battleground, not sure if that makes any sense.
Thanks
POWER NEEDED TO COMPLETE BATTLEGROUND
Defense Bgs Level Bestiary Occult Cavalry Infantry Total Offense Bgs Level Bestiary Occult Cavalry Infantry Total
0 Orc Encampment 148 564 424 2733 2438 342,960
Refugee Camp 136 10400 7059 23100 81700 3,813,540 Catacombs 147 4479 17664 10695 21012 3,399,300
Refugee Camp 136 2 15 11 132 4,140 Orcish Atlar 147 37499 701 442 1694 4,640,310
0 Orcish Atlar 143 20300 18300 3796 2263 4,378,650
0 Ogre's Cave 142 9354 5198 24800 39500 4,263,300
Village 133 37700 1982 6473 11100 3,615,840 Catacombs 138 -
Village 130 33300 3819 587 24900 3,414,620 -
Tower of Mages 129 2924 6036 54900 24600 3,284,080 Ogre's Cave 128 -
Village 127 3872 11400 84 108700 3,171,120 Ogre's Cave 126 -
Village 126 20300 23600 1462 168 3,101,840 Orcish Atlar 125 -
Village 125 20100 11400 5559 23000 2,974,360 Orcish Atlar 119 -
0 Catacombs 111 -
Presidio 123 32100 4020 505 307 2,835,540 Orc Encampment 107 -
0 Orc Encampment 96 -
0 Orcish Atlar 95 -
0 Orcish Atlar 95 -
Village 100 2780 1172 6524 46582 1,485,320 Orc Encampment 94 -
Vill 719 95 2012 7718 4789 20400 1,223,600 Catacombs 94 -
Presidio 94 7548 3042 550 20200 1,212,360 Ogre's Cave 94 -
Refugee Camp 94 7498 3843 4514 10100 1,212,980 Catacombs 83 -
Presidio 93 3715 457 882 39900 1,157,900 Orc Encampment 69 -
Tower of Mages 92 634 1219 3038 1393 273,240 Orc Encampment 52 -
0 Catacombs 50 -
0 Ogre's Cave 47 -
0 Orcish Atlar 45 -
0 Catacombs 39 -
0 Ogre's Cave 33 -
0 Orcish Atlar 18 -
0 Ogre's Cave 6 -
TROOPS NEEDED TO COMPLETE BATTLEGROUNDS TROOPS NEEDED TO COMPLETE BATTLEGROUNDS
Troops Level Power Troop Amount Troops Level Power Troop Amount
Archer 24 43 32,780,480 Pikeman 30 98 17,024,520
Dwarf 22 49 Paladin 32 153
Lost One 20 67 Seeker 20 169
Huntress 20 67 Pathfinder 20 169
Reiter 20 292 Knight 30 565
Nomad 20 292 Priestess 20 776
Barbarian 20 292 Great Lord 20 776
Golems 20 759 Reaver 20 776
Demon 20 787 Warlock 20 1646
Griffin 20 1109 Necromancer 26 2166
Undead Dragon 20 1675 Renagade 20 2607
Silent One 30 70.1 Chimera 20 1988
Assassin 20 64.7 Wyvern 20 3181
Succubus 20 92.7 Dragon 20 3711
Not copy and paste (have you seen your post after it has been published?) - just attach a sample (simplified but keeping the general layout) workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks