PERCENTAGES @members

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3140276%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EPERCENTAGES%20%40members%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3140276%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3Ehello%2C%20I%20am%20learning%20excel%20for%20the%20first%20time%20in%20college.%20I%20don't%20know%20what%20I%20am%20doing%20wrong.%20I%20highlighted%20the%20question%20that%20is%20being%20asked%20of%20me%2C%20what%20formula%20I%20chose.%20My%20instructor%20gives%20us%20a%20finished%20sheet%20with%20the%20answers%20but%20I%20am%20clueless%20as%20to%20figure%20out%20which%20formula%20to%20use.%20Please%20help!%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346466iC02D068D8730DE4B%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Screenshot%202022-02-08%20180434.jpg%22%202022-02-08%3D%22%22%20180434.jpg%3D%22%22%20alt%3D%22Screenshot%202022-02-08%20180434.jpg%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346467i18AE85D7F7B55426%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Screenshot%202022-02-08%20180704.jpg%22%202022-02-08%3D%22%22%20180704.jpg%3D%22%22%20alt%3D%22Screenshot%202022-02-08%20180704.jpg%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346469iC02256BC68D72E34%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22ss.jpg%22%20alt%3D%22%5C%26quot%3Bss.jpg%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3140276%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EOffice%20365%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

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