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