PERCENTAGES @members

Copper Contributor

hello, I am learning excel for the first time in college. I don't know what I am doing wrong. I highlighted the question that is being asked of me, what formula I chose. My instructor gives us a finished sheet with the answers but I am clueless as to figure out which formula to use. Please help!

 

 

 

Screenshot 2022-02-08 180434.jpgScreenshot 2022-02-08 180704.jpgss.jpg

1 Reply

@Italianwifey2008 

 

What I see in the selected formula is (F4--G4)/F4.  The double-minus is wrong.  Ostensibly, it should be (F4-G4)/F4.

 

ERRATA....  And actually, I think it should be (F4-G4)/G4, or equivalently F4/G4 - 1, since you want 4th quarter change over 3rd quarter, and F4 is 4th quarter and G4 is 3rd quarter.

 

JoeUser_0-1644363341777.png