- 1 025
- 5 797 777
How To Videos And Tips
United Kingdom
Registrace 3. 08. 2006
CZcams is the go to site for solutions to DIY, Car Repairs, Home Repairs, Skills . I've always had a passion for sharing tips,skills, short-cuts.
How to Videos and Tips
How to Videos and Tips
How to Convert Currency in Monday.com
If you need to convert currency in Monday.com, you currently need to use formulas to do so. These work in a similar way to formulas in Microsoft Excel.
0:03 Introduction to my Purchase Board
0:56 Method 1 (2 currencies only, IF)
5:22 Troubleshooting formula errors
5:56 Method 2 (multiple currencies, SWITCH)
8:43 Adding $ sign and number formatting
Here are some formulas you can copy-paste. Method 2 is easier to use than Method 1:
Method 1 (2 currencies only):
With $ sign in front:
TEXT(
IF({Currency}="USD",MULTIPLY({Quote Price},1.34),MULTIPLY({Quote Price},1))),$##,##.00)
Without $ sign in front:
IF({Currency}="USD",MULTIPLY({Quote Price},1.34),MULTIPLY({Quote Price},1))
Method 2 (multiple currencies):
With $ sign in front:
TEXT({Quote Price}SWITCH*({Currency}="USD",1.34,"CAD",1,"EUR",1.47,"GBP",1.71),$##,##.00)
Without $ sign in front:
{Quote Price}SWITCH*({Currency}="USD",1.34,"CAD",1,"EUR",1.47,"GBP",1.71)
Add text formatting to a formula:
TEXT((Formula),"$##,##.00")
0:03 Introduction to my Purchase Board
0:56 Method 1 (2 currencies only, IF)
5:22 Troubleshooting formula errors
5:56 Method 2 (multiple currencies, SWITCH)
8:43 Adding $ sign and number formatting
Here are some formulas you can copy-paste. Method 2 is easier to use than Method 1:
Method 1 (2 currencies only):
With $ sign in front:
TEXT(
IF({Currency}="USD",MULTIPLY({Quote Price},1.34),MULTIPLY({Quote Price},1))),$##,##.00)
Without $ sign in front:
IF({Currency}="USD",MULTIPLY({Quote Price},1.34),MULTIPLY({Quote Price},1))
Method 2 (multiple currencies):
With $ sign in front:
TEXT({Quote Price}SWITCH*({Currency}="USD",1.34,"CAD",1,"EUR",1.47,"GBP",1.71),$##,##.00)
Without $ sign in front:
{Quote Price}SWITCH*({Currency}="USD",1.34,"CAD",1,"EUR",1.47,"GBP",1.71)
Add text formatting to a formula:
TEXT((Formula),"$##,##.00")
zhlédnutí: 310
Video
How to Understand the Kentei Level 10 Practice Exam - Part 2
zhlédnutí 47Před 8 měsíci
The Kentei Level 10 exam is the easiest of the Kanji tests, and is taken by 7-year-olds in the Japanese schooling system. In Part 2 of this video I go through the practice exam paper in more detail, translating each question and some of the more difficult exercises to help you through some of the more difficult vocabulary. As there is only one practice paper available, I recommend trying to sit...
How to Understand the Kentei Level 10 Practice Exam - Part 1
zhlédnutí 134Před 8 měsíci
The Kentei Level 10 exam is the easiest of the Kanji tests, and is taken by 7-year-olds in the Japanese schooling system. In this video I go through the practice exam paper uploaded by the test organization to help you understand the different types of questions they ask. It's a 40-minute written test and you need at least 70% score to pass (105 out of 150 points). You can download a copy of th...
Samsung Dishwasher DW80N3030US Features
zhlédnutí 1,3KPřed 8 měsíci
0:20 Exterior Buttons 0:46 Cycles 1:42 Water Use, Running Time and Temperatures 2:15 Options 2:55 Locking the Touch Panel 3:36 Delay Start 3:48 Start, Cancel & Drain 4:50 Cycle Stage Indicators 3:55 Detergent & Pre-Wash Dispensers 6:59 Racks and Cutlery Basket Useful Features
How to clean Samsung Dishwasher Filters and Interior Model DW80N3030US
zhlédnutí 479Před 8 měsíci
0:05 Sanitize Cycle 0:24 Removing Dishwasher Rack and basket 1:19 Removing Filter Parts 2:35 Washing Filter Parts 3:52 Replacing Filter Parts 5:06 Replacing Rack and basket 6:18 Cleaning common mold areas Download the user manual here: downloadcenter.samsung.com/content/UM/202312/20231219145639180/User_Manual_DW80N3030.pdf
How To Plug In Your USB Cable / Stick The Right Way Up First Time With This Trick
zhlédnutí 626Před rokem
No more fumbling trying one way then the other way. With this trick you can insert your USB cord the correctly polarized first time and every time. Instructions 1) Locate side of USB with Trident Logo 2) If No Logo locate Side with two Holes (Not the side with blocked Holes) 3) This means the 'Empty' part of the Plug is upwards 4) Locate the colored Plastic Tab in the USB Socket 5) Now Connect/...
How to Open / Close / Use an Isolation Valve (Service Valve)
zhlédnutí 16KPřed rokem
What Is An Isolation Valve? An isolation valve allows you to instantly cut off the water supply to a particular tap/faucet or washing machine so that you repair or replace the tap/faucet without having to shut down the water supply for the entire building. An isolation valve is a fitting within the plumbing pipework. They are also referred to as service valves. It can either allow water to flow...
How To Attach STIRRUP Pump Nozzle / Head to a SHRADER VALVE (The TRICK) LIFEHACK
zhlédnutí 93Před rokem
The Head needs to be pushed on sufficiently to depress the inner valve otherwise you will not be able to pump air in. The Rubber Nozzle / Head is rather tight so the trick is gently twist as you press see the the video
St Peter and St Paul Church Appleford with its Soaring Tower
zhlédnutí 77Před 2 lety
Appleford Church is a landmark for miles around. The tower and spire are visible from Wittenham Clumps and Sires Hill, from all the local roads and from the Oxford to Paddington railway and the Thames Footpath. St Peter and St Paul Church is open for visitors throughout the year. There are copies of the Parish Registers in the church for perusal. An informal ‘Family Breakfast Church’ takes plac...
How To Open VW Polo Bonnet / Hood 2017-onwards 6th Generation (Not Broken)
zhlédnutí 24KPřed 2 lety
#BONNET #HOOD Step 1) Locate Bonnet / Hood Release Lever inside RIGHT HAND SIDE door-well Step 2) Pull Door-Well SAFETY Lever to Release Bonnet / Hood to First Click (Enough to get your fingers underneath) Step 3) Move to the Front of the car Step 4) Locate the Under Bonnet/Hood Release Lever which is in the GAP above the VW Badge Step 5) The Lever is connected to the Car not the Bonnet so curl...
How To Open Mercedes E 320 BONNET / HOOD (NOT BROKEN)
zhlédnutí 29KPřed 2 lety
#BONNET #HOOD Step 1) Locate Bonnet / Hood Release Lever under Drivers Dashboard Step 2) Pull Door-Well SAFETY Lever to Release Bonnet / Hood to First Click (This Releases through bonnet T-Bar) Step 3) Move to the Front of the car Step 4) Locate the T-Bar Lever which above the Mercedes Logo Step 5) Pull T-Bar Lever and Lift Bonnet / Hood simultaneously with other hand To Close 1) CHECK you have...
How to Replace Broken Plastic Gear on Your Nutribullet (Remove Brass Nut)
zhlédnutí 17KPřed 2 lety
Before buying a replacement plastic gear disk make sure you can remove the brass nut. When the disk breaks it leaves behind the inner brass nut on the spindle. This nut is necessarily pretty tightly and in our case for over 5 years. lubricate the nut with WD40 it won't be enough but might make the job a little easier. Instructions:- Unplug the Nutribullet Unscrew the bottom cover. Try to undo t...
Unboxing Assembling & Inflating WattSUP Stand Up Paddle
zhlédnutí 1,4KPřed 2 lety
If possible assemble first in your garden/shed (practice) Remove all contents from the box CHECK ALL ITEMS INCLUDED PADDLE (2/3 sections) REPAIR KIT (ORANGE TUBE) FOOT SAFETY STRAP FIN WITH CLIP PUMP WITH SEPARATE FLEXIBLE PIPE INSTRUCTION BOOKLET INFLATABLE FOLDED SUP WITH STRAP (NOW TAKE A PHOTO OF EVERYTHING BEFORE UNWRAPPING) 1) Connect Pipe to the Pump (it's only a 3/4 turn) 2) Assemble Pa...
How To Zip Up A Backpack / Bag Without Snagging the Linings (Lifehack)
zhlédnutí 92Před 2 lety
Use Thumb & Adjacent fingers to Hold the Zip Pull Place remaining three fingers inside & underneath the zip. The two outer fingers deflect the inner flaps. After a few tries it becomes second nature. If the zip is stiff try lubrication with say a Silicon Lubricant.
How To Locate Ford Focus Spare Tyre & Jack & Repack Afterwards
zhlédnutí 25KPřed 2 lety
Spare (Emergency Tyre) under the boot floor. Lift and remove the Boot floor (not fixed) by getting fingers under an edge Undo the Bolt which has a handle that is retaining the Tyre. Store Bolt & Plastic Retaining Disk carefully Lift out the Emergency Wheel. The Jack & tools are now visible (Advice) Take a PHOTO of the tools so you easily put them back into the Plastic Holder You should have a J...
How To Open Tricky DS7 Crossback Bonnet / Hood (not broken) DS 7
zhlédnutí 7KPřed 2 lety
How To Open Tricky DS7 Crossback Bonnet / Hood (not broken) DS 7
How to Clean Siemens Washing Machine Filter (No tools required)
zhlédnutí 6KPřed 2 lety
How to Clean Siemens Washing Machine Filter (No tools required)
How To Disable Redmi Boot / Startup Sound / Audio . Step by Step Instructions. MIUI
zhlédnutí 2,4KPřed 2 lety
How To Disable Redmi Boot / Startup Sound / Audio . Step by Step Instructions. MIUI
How to Use A Bike Floor / Stirrup Pump to Inflate a Tyre / Tire
zhlédnutí 548Před 2 lety
How to Use A Bike Floor / Stirrup Pump to Inflate a Tyre / Tire
How to Open Volvo V60 Bonnet/Hood (Not Broken)
zhlédnutí 13KPřed 2 lety
How to Open Volvo V60 Bonnet/Hood (Not Broken)
How to Open Ford B Max Bonnet / Hood (not broken) bmax b-max
zhlédnutí 5KPřed 2 lety
How to Open Ford B Max Bonnet / Hood (not broken) bmax b-max
How To Open Ford Fiesta Bonnet / Hood MK6 2008-2017
zhlédnutí 50KPřed 2 lety
How To Open Ford Fiesta Bonnet / Hood MK6 2008-2017
How To Make a Cappuccino with a Tassimo | How to Insert Pods
zhlédnutí 15KPřed 2 lety
How To Make a Cappuccino with a Tassimo | How to Insert Pods
What does BAZBALL Mean? | The Winning Principles of BAZBALL
zhlédnutí 580Před 2 lety
What does BAZBALL Mean? | The Winning Principles of BAZBALL
How to Open Toyota Corolla Hybrid Bonnet / Hood (non-broken)
zhlédnutí 11KPřed 2 lety
How to Open Toyota Corolla Hybrid Bonnet / Hood (non-broken)
How To Disable Facebook Notification Beep on Your PC Browser : Step by Step Instructions
zhlédnutí 1,2KPřed 2 lety
How To Disable Facebook Notification Beep on Your PC Browser : Step by Step Instructions
How To Eliminate a Small Selfheal Lawn Infestation (Prunella Vulgaris)
zhlédnutí 1,1KPřed 2 lety
How To Eliminate a Small Selfheal Lawn Infestation (Prunella Vulgaris)
How To Remove Dried Birdshit / Bird Poop / Bird Lime from your Car
zhlédnutí 276Před 2 lety
How To Remove Dried Birdshit / Bird Poop / Bird Lime from your Car
How To Close Difficult Mercedes B200 Bonnet / Hood
zhlédnutí 2,8KPřed 2 lety
How To Close Difficult Mercedes B200 Bonnet / Hood
How To Choose a Reliable Non-Stick Wok Which will LAST
zhlédnutí 71Před 2 lety
How To Choose a Reliable Non-Stick Wok Which will LAST
What the fuck man? A rag like that can remove the stains without Baking soda too..
Even though this video is 5 years old, it’s still helping people. It helped me today! Thanks!
Thanks! Another mystery solved. No instructions on the dispenser.
Martin Michael Davis Lisa Gonzalez Anna
This alone would stop me from buying one of these cars.
Thank u ....its so helpful...
You saved the day 🎉
Thank you!
Thanku
WTF. 🤡
Thanks !!!
Tube diameter?
Hey! I just got a Renault Laguna 2006. It has the same container for the coolant as yours. I find it quite difficult to read the min and max line of the coolant, as it is on the top and not on the side of the container as it usually is. Do you know how I should be filling it?
Hey! I just got a Renault Laguna 2006. It has the exact same coolant jug as yours. I find it quite difficult to read the min and max line, as it is on the top and not on the side of the jug as it usually is. Do you know how I should be filling it?
Thanks so much you explained it great. Lisa
Thank you very much, your video helped me tremendously!!!!
I’ve heard that set to become Abingdon‘s first mosque
Ty for saving me with into the pit
Soap strugglers - watch till the end of the video!!
Unfortunately the T lever on my vehicle is encased in a pouch in the grill. Has anyone else experienced this?
Thankyou!
The fact that I have to google this video 😅whew!
You just saved my life with this video, had milk leaking everywhere?? You solved the problem thank you thank you thank you! Brilliant
Thanks mate, very straight to the point and informative
Thank you
Searched for Espresso Megamix ... nek minnit
Very helpful, thanks for sharing
Thank you. I knew it had to be simple but my 'low IQ' would not let me work it out by myself 🙂
Qm ta aq pra pegar o spob no bear alpha?
Thanks for your short vid
The bag 😂 worked Thanks
Thanks❤
THANK YOU
I love that, very nice. ❤
Thanks, I needed this for a minigame in FNAF: Into the Pit.
How can I do on other side
Another plot to drive us totally bonkers! LOL Thanks for saving my poor brain until the next onslaught!
donde se puede comprar esas barras portaequipajes de techo tengo el mismo modelo de vehiculo
Thank you, I couldn't find how to remove this type of top spray arm and was worried about damaging it. You solved it. Thank you!
Thank you buddy
Thank you soo much 😂
ANTI-CLOCKWISE! That's been the secret the whole time lol
Really helpful thanks!
I built that haha,,!
I built that. Haha !😊
I built that haha
Thanks
Strange how we're pushed to think "microplastics,plastic,waste, pollution,problem,planet,etc....' and these clever machines are allowed to produce billions of small plastic waste pods probably every day, globally...It doesn't make sense to my simple reasoning.... Enjoy your cafe au lait though
Very helpful thank you 👍
Cool