Look up ... I think ???

**domlis** · 07-31-2012, 05:22 AM

Hi every one. I am running multiply formulas on multiply sheets.

I have a cell that is auto calc a %. so as other cells add up this cell continually changes. what formula would i use to then look at another sheet and display a amount based on a given percentage.

example

a1 - 101%

sheet 2
a1 = 101 b1= $1000

i want to auto show $1000 in sheet 1 a2 as sheet 1 shows 101 %

PLEASE HELP !!!!

---------- Post added at 07:16 PM ---------- Previous post was at 06:59 PM ----------

hi kevin, can you help?

---------- Post added at 07:22 PM ---------- Previous post was at 07:16 PM ----------

anyone please

**Pete_UK** · 07-31-2012, 05:28 AM

Don't be so impatient !!

It would help if you were to explain your requirements more clearly, and give details of the formulae you are using. An example workbook to illustrate your data layout and what you have already, as well as your desired output, would also help.

Pete

**domlis** · 07-31-2012, 05:35 AM

Ok so i have different sheets for different sales reps. Each rep has their own target and commission amount. As the sales come in i have a cell auto calculating the total and giving a percentage based on that reps target.
On a hidden sheet i have a chart that shows the percentage earnt and the percentage paid.... Example If you earn 102% we pay 104% which is equal to $1,500. On john's sheet i want to show just $1500. Obviously if he was to put in another sale then i want it to show the new commission.
example new percentage is 110% which we pay 125% so $3000

On the hidden sheet i have 3 columns

% Achieved % Earnt $ paid
105 110 $2500

**Pete_UK** · 07-31-2012, 05:41 AM

Well, that tells us a lot about which columns you use, the cells where you want the formula to go, the sheet names you have - NOT.

Why don't you post a sample workbook?

Pete

**Pepe Le Mokko** · 07-31-2012, 05:42 AM

Originally Posted by domlis

Hi every one. I am running multiply formulas on multiply sheets.

I have a cell that is auto calc a %. so as other cells add up this cell continually changes. what formula would i use to then look at another sheet and display a amount based on a given percentage.

example

a1 - 101%

sheet 2
a1 = 101 b1= $1000

i want to auto show $1000 in sheet 1 a2 as sheet 1 shows 101 %

PLEASE HELP !!!!

---------- Post added at 07:16 PM ---------- Previous post was at 06:59 PM ----------

hi kevin, can you help?

---------- Post added at 07:22 PM ---------- Previous post was at 07:16 PM ----------

anyone please

Please note that forum rules ask to wait 24 hrs before bumping.

If you have a very urgent request, pay sites are available. Everybody here is helping for FREE on his spare time. Please respect that !

**domlis** · 07-31-2012, 05:54 AM

Sorry, first toime user and did not know rules simply i saw people looking and thought it was like a chat thing

**domlis** · 07-31-2012, 05:59 AM

Tracking.xlsx

spead sheet attached

as Z8 % changes i would like to show amount on commission sheet that rep is paid

**zbor** · 07-31-2012, 06:42 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.