Forum Discussion

Basilowl's avatar
Basilowl
Copper Contributor
Feb 11, 2020
Solved

Excel profit and loss statement

Hi my nephew is starting to sell on ebay and I was trying to do a formula so he can see his profits and I can't seem to get it right.  Can someone tell me what I am doing wrong?  I have attached the ...
Formulas and Functions
  • PReagan's avatar
    PReagan
    Feb 12, 2020

    Hello Basilowl,

     

    There are many ways that this could be accomplished. Here are just a couple of ways:

    =SUM(C2,-SUM(D2:H2))
    {=SUM(C2,-(D2:H2))}   Press Ctrl+Shift+Enter 

     

PReagan's avatar
PReagan
Bronze Contributor
Feb 12, 2020

Hello Basilowl,

 

There are many ways that this could be accomplished. Here are just a couple of ways:

=SUM(C2,-SUM(D2:H2))
{=SUM(C2,-(D2:H2))}   Press Ctrl+Shift+Enter 

 

Resources