Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jordan
 
Posts: n/a
Default Estimating figures

I have four sets of numbers say
100
200
300
400
I also have a set of numbers that correspondes and is multipled to the
number above
1
2
3
4
so it would be
100x1
200x2
300x3
400x4
The total would be 3000

Here is my problem the 100, 200 etc numbers wont change. The 1,2 etc
numbers might but I wouldnt know what to, I would however know that the 3000
total changed to say 3300. If there a formula or a way to figure out what
the different numbers 1,2, etc may have changed too?

I am using round number for this example. In real life the numbers will be
such that chances are there would only be one senioro that would match.

Any help will be appreciated.

Thanks.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing positive figures to minus figures Louise Excel Worksheet Functions 2 September 14th 05 10:05 AM
Formula to strip figures from cells text strings mikeburg Excel Discussion (Misc queries) 5 August 15th 05 10:31 PM
calculate minus figures Nigel Excel Discussion (Misc queries) 1 March 30th 05 04:33 PM
calculate minus figures only Nigel Excel Discussion (Misc queries) 2 March 30th 05 12:03 PM
Calculate minus figures only Nigel Excel Discussion (Misc queries) 0 March 30th 05 10:31 AM


All times are GMT +1. The time now is 02:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"