Це відео не доступне.
Перепрошуємо.

Working with functions and percentage in Google Sheets

Поділитися
Вставка
  • Опубліковано 12 лис 2017

КОМЕНТАРІ • 74

  • @blockPawn1924
    @blockPawn1924 4 роки тому +67

    skip to 6:31 for percentage

    • @loaf9672
      @loaf9672 4 роки тому +2

      This reminds me to always read the comments before watching a video! lmao
      thanks.

  • @catherinedesormeau2700
    @catherinedesormeau2700 4 роки тому +6

    You sir are doing the Lord's work, as someone who's newly landed in a job where Excel/Sheets are a major player and I've never had to use it before YOU ARE AMAZING!! so simply explained thank you :)

  • @loaf9672
    @loaf9672 4 роки тому

    Thank you Jeffrey. Can't say enough how useful this simple percentage formula was!

  • @praptinegi9365
    @praptinegi9365 Рік тому +1

    thank u sir
    you made my college assignment task lot simpler.

  • @bmompie
    @bmompie 3 роки тому

    You are definitely my go to resource for years now... thank you for all that you do

  • @nathanrainer1882
    @nathanrainer1882 4 роки тому +1

    YEAH!!!!! Thanks! I've been trying to figure out the $ symbol trick for a minute! Thanks a lot!

  • @pedromonsivais657
    @pedromonsivais657 2 роки тому

    Thank you! it helped me a bunch. I used google free spreadsheet, it worked the same.
    Thanks for taking your precious time to teach us.

  • @jsingle76
    @jsingle76 5 років тому +2

    Thanks so much. I couldn't remember for the life of me the formula for calculating percentage from the grand total with the $. You just saved me about an hour of work! :)

  • @bedantasvlog2650
    @bedantasvlog2650 3 роки тому

    Percentage was the real deal damn saved my day

  • @oooo0O0oooo
    @oooo0O0oooo Рік тому

    Awesome, Thank you sir.

  • @cmasiktamukherjee1842
    @cmasiktamukherjee1842 3 роки тому

    Thanks a lot, very helpful video for beginners, a well defined calculation percentage and all for google sheet

  • @winwithvinhphan
    @winwithvinhphan Рік тому

    very helpful thank you Jeffrey

  • @rongtianhuangTimmmh
    @rongtianhuangTimmmh Рік тому

    Amazing video

  • @rezaulrahaman4697
    @rezaulrahaman4697 2 роки тому

    Thank you so much Sir very helpful video......

  • @sakanablesakanable
    @sakanablesakanable 11 місяців тому

    You are a lifesaver Jeffrey,

  • @fadedarmy2101
    @fadedarmy2101 7 місяців тому

    Thank you nobody else has shown it better

  • @bsolano1234
    @bsolano1234 2 роки тому

    Awesome! So helpful and explained well. Thank you!!

  • @drewismclovin
    @drewismclovin Рік тому

    Super useful, Thank you for shortening my time on excel :'D

  • @dauthuc8807
    @dauthuc8807 Рік тому

    Thanks mr keep it up

  • @Startrack16
    @Startrack16 Рік тому

    GREAT VIDEO

  • @mitziyoung5873
    @mitziyoung5873 2 роки тому

    Thank you so much! you are a great teacher

  • @chadbaron8790
    @chadbaron8790 17 днів тому

    Jeff,
    Question. I'm a coach, trying to track shot % (makes / attempts) on a daily basis. I tried the b4/$c$4 and then I drag down to copy the formula. It changes the 1st cell b5, b6, b7, etc. but it is anchored to $c$4 cell. How do I get the formula to adjust to each row and not be anchored to the original cell? Thanks in Advance!

  • @markaaroneugenio4036
    @markaaroneugenio4036 Рік тому

    Very helpful! Thanks brother!

  • @divaloca8039
    @divaloca8039 4 роки тому

    TYSM you are a life savior.

  • @christianogoncalves9460
    @christianogoncalves9460 2 роки тому

    Thank you so much for this! Really helpful

  • @trentonjames3121
    @trentonjames3121 Рік тому

    THANK YOU SO MUCH SIR!!!

  • @mateosanzpedemonte7342
    @mateosanzpedemonte7342 Рік тому

    Very helpful! Thank you

  • @francishubertovasquez2139
    @francishubertovasquez2139 2 місяці тому

    Was a universe science interpretation about PAttern of energies PAthways and MAtter wavelengths of Masses of AToms and MOlecoles and Spirals ( ATMOS) done in area of DArk Energy in Purple of Soft Science things and LIghts and Bounds of Energies (DAEPSS or Deeps / Depths ) ( LIBE or Live ), where Particles are parts of each other side of Calculation.

  • @erikaweirdsurname4150
    @erikaweirdsurname4150 2 роки тому

    Amazing, thanks!

  • @mehertonse1332
    @mehertonse1332 4 роки тому

    Excellent guidance. Thank you

  • @essaramzan5782
    @essaramzan5782 4 роки тому

    Helpful 😊

  • @Romanosanius
    @Romanosanius 2 роки тому

    This is amazing, thank you very much

  • @AliciaMeehan
    @AliciaMeehan Рік тому

    Thank you for this!
    Can you add a specific percentage? Example,
    Add a Specific percentage from the total above.

  • @inspiredbylife1774
    @inspiredbylife1774 2 роки тому

    I think hitting F4 automatically add the dollar symbols for a cell reference.

  • @stalebread7972
    @stalebread7972 4 роки тому +1

    Thank you, God bless

  • @jean-claudelionbeat3325
    @jean-claudelionbeat3325 6 років тому

    Solved my issue re. formula not replicating correctly down the column. All about those $$ signs! Thank you!

  • @sharifrahim4837
    @sharifrahim4837 5 років тому

    i never comment, but for you i did, Thanks

  • @neeruaggarwal1942
    @neeruaggarwal1942 2 роки тому

    Thank you very much

  • @anjulalakmal4526
    @anjulalakmal4526 Рік тому

    Thank You !! Sir

  • @Sheenbeanie
    @Sheenbeanie 3 роки тому

    Thanks for this video! What happens if I want to calculate percentages but then happen to add a row (say chai latte) later on? Do I have to redo the formulas?

  • @marvelousmeet2005
    @marvelousmeet2005 4 роки тому +1

    Thank you so much .

  • @nairdaboss
    @nairdaboss 2 роки тому

    thanks my boi

  • @yonatanfadega7886
    @yonatanfadega7886 3 роки тому

    thank you so much you helped a lot

  • @LyndsayKJ
    @LyndsayKJ 4 роки тому

    Hi there! How do I create a function to subtract the values in each cell of a column from another column. Say, subtract the entire column (each cell) of Column A from Column C, then have the difference of each cell show up in Column D?

  • @Andrew-vr9hr
    @Andrew-vr9hr 5 років тому

    Thank you. I couldn’t find how to do this anywhere. Idk why they make it so hard to make a percentage lol

  • @WhammoFTW
    @WhammoFTW 2 роки тому

    THANK YOU!

  • @yllenamorana4319
    @yllenamorana4319 3 роки тому

    Thank you!

  • @questionresearch8721
    @questionresearch8721 2 роки тому

    Thank you.

  • @randomblueper6689
    @randomblueper6689 6 років тому

    Thank you, this is very helpful.

  • @MikeDunn
    @MikeDunn 6 днів тому

    Please, for the love of God, tell me how to draw a horizontal line as you did at the bottom of rows 2 and 11. Thanks.

  • @vardhagallabhavani1232
    @vardhagallabhavani1232 5 років тому

    verry helpfull

  • @vuledzanimabulela890
    @vuledzanimabulela890 Рік тому

    thanks

  • @johnc7433
    @johnc7433 5 років тому

    Why don't you just use Autosome function? Easier, right?

  • @cleotinareviews
    @cleotinareviews 4 роки тому

    Thank you

  • @jackieluv2090
    @jackieluv2090 9 місяців тому

    I’m so confused…
    I want to find 10% of a Column!!

  • @muhammadshahidshahid5034
    @muhammadshahidshahid5034 5 років тому

    Thanks I am so worried but I know how to do this that time I dont know now l know 😁

  • @34Paperclips
    @34Paperclips 4 роки тому

    Thanks!

  • @rastlonadjalin9455
    @rastlonadjalin9455 3 роки тому

    Thanks

  • @merysarivera1354
    @merysarivera1354 4 роки тому

    thankss!!!
    6:13 for %%

  • @javier33133
    @javier33133 5 років тому

    Thank you. :)

  • @aileendioso561
    @aileendioso561 5 років тому

    Thank you!!!

  • @zlanaj
    @zlanaj 2 роки тому

    I can‘t wrap my head around how to calculate the amount result from 60% from a total amount.

  • @ayahelm.4290
    @ayahelm.4290 4 роки тому

    THANK UUUUUUUU

  • @vincentsquitieri2084
    @vincentsquitieri2084 4 роки тому

    How can I contact you for help? Thank you.

  • @mannydhami8797
    @mannydhami8797 4 роки тому

    Or you could just press F4 to hold cell

  • @denmarkmores5679
    @denmarkmores5679 9 місяців тому

    7:30

  • @felixferalis
    @felixferalis 2 роки тому

    and the winner is Espresso

  • @user-fz8hc5ji9e
    @user-fz8hc5ji9e 10 місяців тому

    Hi

  • @prateekauctus1016
    @prateekauctus1016 3 роки тому +1

    Gosh please consider less talking, more work! Thanks

  • @mediaiweb
    @mediaiweb 4 роки тому

    long-winded though, i wish he could just get to the point

  • @kkal2
    @kkal2 6 років тому

    Thank you!

  • @wavesurfers3568
    @wavesurfers3568 4 роки тому

    Thank you

  • @muhammadshahidshahid5034
    @muhammadshahidshahid5034 5 років тому

    Thanks