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 

 

Basilowl's avatar
Basilowl
Copper Contributor
Feb 12, 2020

PReagan   Thank you so much!  It turns out it was my personal excel is not doing formulas.  I was trying it on my work excel and the formulas did their job.  I appreciate your help

  • PReagan's avatar
    PReagan
    Bronze Contributor
    Feb 12, 2020

    Basilowl 

     

    My pleasure!

  • Basilowl's avatar
    Basilowl
    Copper Contributor
    Feb 12, 2020

    PS I had show formulas on. I never use excel so that’s what the error was. Thanks again

Resources