There probably was more. It showed a range and said enter formula that will
show total profit. The formulas are driving me crazy. I am new to Excel and
all the new job apps require excel tests. The Excel for dummies book is
confusing. Thanks so much for helping.

"RagDyer" wrote:

Was there no specific scenario assumed?

Price minus cost yields profit.
Price in A1
Cost in B1
Profit in C1 by using a formula of:

=A1-B1

There has to be more to it then what you're stating!

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"meri" wrote in message
...
I was asked a question on a test "enter the formula that will show profit"
can someone tell me what that formula should have been (I got it wrong)