Check out some similar questions!

mscathieann · May 11, 2009, 07:55 PM

Billable makes up two cells H&I and $=4% labor is J I make $250.00 billable and I need to fine the percentage for my Commission in J I need a formula that will allow me to get 4% if billable and put the answer in Comm (j)

Billable 4% 10%
Materials Comm. Labor Comm.

Unknown008 · May 12, 2009, 10:14 AM

Well I don't really understand what you mean...

Try using (4/100)*cell ID

By billable... you mean that the sum should be above $250 for the percentage to be calculated? Try searching in the help section, search for conditions. I don't have Windows, but I have Linux. I'm not sure if the commands are the same.

KISS · May 12, 2009, 10:59 AM

You would be better off making the for a constant from say $a$2 where a1 = "Materials commission" and $a$2 = 4. Format $a$2 in percent

and you can just multiply. The /100 will be done for you.

=H3*$A$2
=H4*$A$2; from a fill down operation

if H3 is the billable amount and $a$2 is the commission in %, like 4. and the is the formula for the commissions.

Not a good explanation, but neither was your question.

I think you need to use a constant for the commissions, hence the use of the $ variables. This makes that cell content not move in a relative fashion.