Finding a value if you enter a percentage

  • Thread starter Thread starter Kelly A
  • Start date Start date
K

Kelly A

I need to know a formula for calulating a dollar amount.
If in cell A32 I enter the number of people and in cell
G26 I enter a dollar amount then in cell J32 I enter a
persentage from 0% to 100% I want cell I32 to display the
dollar amount for the percentage of people.

Iam Using
Office XP
 
Hi Kelly,

I think what you are looking for is $/(People*%). If so, try:

=G26/(A32*J32)

which for $100, 25 people, and 4% would return $100

tim
 
That didn't do it but I change it a little =J32*(G26*A32)
and it came close. Ill try to explain better.
If cell G26 is dollar amount10.00 and cell A32 is number
of people 17. Cell J32 is say 1% then I need the value to
be 10.00 if cell J32 is 50% then I need 85.00 if cell J32
is 100% then I need 170.00
 
That didn't do it but I change it a little =J32*(G26*A32)
and it came close. Ill try to explain better.
If cell G26 is dollar amount10.00 and cell A32 is number
of people 17. Cell J32 is say 1% then I need the value to
be 10.00 if cell J32 is 50% then I need 85.00 if cell J32
is 100% then I need 170.00
 
Hi Kelly,

You and Chuck have it right. I thought you were wanting to know dollars per
person with the number of people variable.

tim
 
In re-reading your posts, maybe this is what you want in I32:

=MAX(G26,(G26*A32*J32))

Vaya con Dios,
Chuck, CABGx3
 
Back
Top