Create custom formulas in Excel

  Рет қаралды 360,826

bytebodger

bytebodger

Күн бұрын

ShowMeAcademy.com - create custom formulas in Microsoft Excel 2007

Пікірлер: 41
@weekendcoder3460
@weekendcoder3460 2 жыл бұрын
Watching on 31st March 2022 From INDIA
@giacomopodda7060
@giacomopodda7060 9 жыл бұрын
Man, thank you so much for this tutorial, I'm so happy that I can finally create those damn formulas :)
@dnnb99
@dnnb99 11 жыл бұрын
Thanks for saving my times!
@sreymomkheang6933
@sreymomkheang6933 11 жыл бұрын
good explanation
@H8Bully
@H8Bully 11 жыл бұрын
Very clear explanation. Thank you for the clip.
@Gruncival
@Gruncival 9 жыл бұрын
These are not custom formulas.
@nopanandechopakornkiart3366
@nopanandechopakornkiart3366 12 жыл бұрын
Thank you for your presentation
@zhihao81
@zhihao81 15 жыл бұрын
Very useful. Thank you.
@royasalehzai5873
@royasalehzai5873 11 жыл бұрын
thank you, but is there any way to create a custom function for a whole list of ranges ??
@rajeshkrishnanck
@rajeshkrishnanck 6 жыл бұрын
wasted 6 mins expecting for a custom formula, please change the header to basic formula in excel
@trinigyal318
@trinigyal318 11 жыл бұрын
very useful...thank you!
@pavan1815
@pavan1815 13 жыл бұрын
Thanx for the video.
@smegraj
@smegraj 13 жыл бұрын
thank you very much!
@AlejandroVidalesAller
@AlejandroVidalesAller 12 жыл бұрын
how do you apply for all Ds the same formula but diferents numbers on each?
@vtorres1980
@vtorres1980 10 жыл бұрын
this should be called "Basic Formulas in Excel" not Custom... it's ok but the voiceover guy even said these are basic formulas...
@microsecure2612
@microsecure2612 5 жыл бұрын
I hope you can help me with this: On sheet1 we have: Amount: B14 Item No: B15 Item: B16 (Combo Box from 1 to 95 items) and it work perfect with item No B15 On sheet2 we have: Amount: D24 Item No: A24 Item: B24 We need to create a formula to transfer the Amount from sheet1(B14) to Amount sheet2 (D24) And if we change the item No on sheet1 for example to number 18 the amount should goes to D25 of sheet2 Many thanks
@Raeb222
@Raeb222 14 жыл бұрын
Helpful thank you
@leslygilcrest335
@leslygilcrest335 9 жыл бұрын
Where can I order an essay?
@lynnealennon7368
@lynnealennon7368 9 жыл бұрын
I've ordered essay at *write-an-essay.all-about.in*. I just didn't realize how much time my essay would take... When I understood it, it was almost too late. Luckily, I have found this site that wrote my essay in 5 hours, and it was just great! There must be real professionals working for the company.
@victorenricoso7730
@victorenricoso7730 7 жыл бұрын
Thank you!
@roobinasadat4561
@roobinasadat4561 12 жыл бұрын
very useful thanks
@37no37
@37no37 13 жыл бұрын
Hi, I am working with positive and negative numbers in the same column using frequency function, but always give me error, I count by hand and is not the same. for example in a column 1,-1,2,3,-2 the anwser must be one time 1 pos. one neg. but with frequency I got 1 seven time. how come.
@patriciayague
@patriciayague 12 жыл бұрын
thank you !
@TheCanadianMystery
@TheCanadianMystery 11 жыл бұрын
Love the tutorial, however I am trying to work out a baseball stats for a graph and I still can not get it to work I have the distance from 1st base second base is 60 feet however from home plate it is 84.8528137424 feet: therefore the likelyhood of stealing is a greatest success is all other varibles were the same. So I have =a2 ( percent of how the runner does in stealing second base) *60 (the feet from second to third) / 84.852813742 second to third ... it wont work
@roulaafeiche8353
@roulaafeiche8353 8 жыл бұрын
HELLO, I need help to create a formula. Example: If column K is Yes, and column F is "Fruit" or "Vegetable" ; then column L should be "Yes". If column F has a different value than Fruit or Vegetable, Then column L should be "NO". And if column K is "No", then column L is "No". May be it is too complicated to create on excel? thank you for your help.
@SAJMALHAQUE
@SAJMALHAQUE 11 жыл бұрын
thank you
@Bodyskillz2011
@Bodyskillz2011 11 жыл бұрын
but how to do all this formulas for all the table ? without repeating it again and again
@jay8278
@jay8278 6 жыл бұрын
Thanks!!
@barazakb
@barazakb 11 жыл бұрын
thank u very much- razak
@MilosCsrb
@MilosCsrb 12 жыл бұрын
thanks ! :*
@ShantanurajPatil
@ShantanurajPatil 11 жыл бұрын
thanks
@rahulshrimali4871
@rahulshrimali4871 6 жыл бұрын
Dear sir, Plz send video of tax + formula in Excel.
@tejatiruveedhula29
@tejatiruveedhula29 9 жыл бұрын
thnx
@babesmanues3548
@babesmanues3548 7 жыл бұрын
it should be =(16×200)
@daLazyCustodian
@daLazyCustodian 9 жыл бұрын
GO PATS!!!!!!! Belichick yourself before you wreck yourself!!! dvd RI!!!
@subasha1016
@subasha1016 6 жыл бұрын
Let's suppose we have User A . A refer B so A Earn 10rs Now A refer C so A earn 10rs Now B refer D and E so A earn (10+10=20) but B also earn (10+10=20) Now c refer F and G so again A earn (10+10=20) but c also earn (10+10=20) and it's going and going can anyone help how to use
@shivarekha
@shivarekha 5 жыл бұрын
damn, came here hoping to know how to create custom formula and wasted my 10minutes. He goes on and on explaining the same thing in detail over and over
@zcrypto351
@zcrypto351 Жыл бұрын
I am 1 year greater than this video😂
@HusamJamal
@HusamJamal 9 жыл бұрын
thank you !
Use data validation in Excel
9:47
bytebodger
Рет қаралды 242 М.
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
14:48
Excel Campus - Jon
Рет қаралды 14 МЛН
Throwing Swords From My Blue Cybertruck
00:32
Mini Katana
Рет қаралды 11 МЛН
МЕБЕЛЬ ВЫДАСТ СОТРУДНИКАМ ПОЛИЦИИ ТАБЕЛЬНУЮ МЕБЕЛЬ
00:20
Touching Act of Kindness Brings Hope to the Homeless #shorts
00:18
Fabiosa Best Lifehacks
Рет қаралды 18 МЛН
Scale a spreadsheet to fit in one printed page in Excel
5:23
bytebodger
Рет қаралды 1,1 МЛН
Excel For Beginners (spreadsheets) HD
12:38
ImzTech
Рет қаралды 1,2 МЛН
Create pivot tables in Excel
6:38
bytebodger
Рет қаралды 189 М.
Basic Excel Formulas - Add, Subtract, Divide, Multiply
12:49
Computerbasics
Рет қаралды 3,8 МЛН
Create drop-down menus in Excel
5:55
bytebodger
Рет қаралды 1,3 МЛН
Excel Spread Sheet Basics - Using a Formula
9:29
Vern Hyndman
Рет қаралды 2,3 МЛН
Throwing Swords From My Blue Cybertruck
00:32
Mini Katana
Рет қаралды 11 МЛН