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.

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.

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.