Feb 08 2022 03:15 PM
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!
Feb 08 2022 03:25 PM - edited Feb 08 2022 04:13 PM
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.