Finding a value if you enter a percentage

[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

 

[Tim Otero]

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

 

[Kelly A]

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

 

[Kelly A]

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

 

[Tim Otero]

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

 

[CLR]

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

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

Vaya con Dios,
Chuck, CABGx3