Help with an easy formula

M

mis2ko

I just discovered this and after seeing all the others mine is easy, but
I can't figure it out.

GROSS SALES - GS (A1)
GOODS Sold - COG (A2)
PAYROLL - PR (A3)

Formula: GS Minus COG + PR, divided by GS
 
D

Dave R.

The way it's written below, it's
(A1-A2+A3)/A1

but, I suspect there is something with a1, a2, or a3 that needs to be done
in a certain order, but it's not written into your sentence that I can see,
maybe;

A1-(A2+A3)/A1

I think though, make sure that whatever is right next to the / has a
parenthesis around the entire value to be divided, or else it would be
divided by the one number first..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top