Automatically translated.View original post

📊 Stop calculating total percentages like this!

📊 Stop calculating total percentages like this!

Because I found a better way. 😏

Finish it... and you'll never go back to your old ways.

Want to be good at Excel like this again?

Click Follow now 👉 @ Excel Data Master

# ExcelTips # ExcelTricks # TextToColumns # ExcelDataMaster # Easier to work# ExcelTips # ExcelTricks # TextToColumns # ExcelDataMaster # Easier Work # Excel # Spreadsheets # Corporate # Accounting # Finance # WorkHacks # Tutorial # sheetsets

2025/8/14 Edited to

... Read moreเวลาคนค้นหา “สูตร excel บวก ลบ คูณ หาร เปอร์เซ็นต์” ส่วนใหญ่เจอปัญหาเดียวกันคือ พอมี % ปนกับตัวเลขแล้วไม่มั่นใจว่าต้อง “คูณ” หรือ “หาร” กันแน่ ฉันเลยสรุปเป็นชีทจำง่าย ๆ พร้อมตัวอย่างที่เจอบ่อยอย่าง 250*20/100 ให้เลย 1) หลักพื้นฐาน: เปอร์เซ็นต์คือส่วนของ 100 - 20% = 20/100 = 0.2 ดังนั้นถ้าจะคิด 20% ของ 250 ใน Excel ทำได้ 2 วิธีที่ผลเหมือนกัน - =250*20/100 - =250*20% ข้อดีของการใช้ 20% คืออ่านง่ายและลดโอกาสพิมพ์ผิด 2) สูตรคูณ/ลดราคา/ภาษี (เจอบ่อยสุด) - “เอา 20% ของ 250” =250*20% - “ลดราคา 20% จาก 250” =250*(1-20%) - “บวก VAT 7% ให้ 250” =250*(1+7%) ทริค: ถ้าต้องการ “ยอดใหม่หลังเพิ่ม/ลด %” ให้จำรูปแบบ (1±%) ไว้ ใช้ได้แทบทุกเคส 3) สูตรบวก-ลบเปอร์เซ็นต์แบบชัด ๆ บางคนเผลอบวก 250+20% ซึ่งผิด เพราะหน่วยไม่เท่ากัน (บาท + อัตรา) ให้ใช้ - เพิ่ม 20%: =250 + (250*20%) หรือ =250*(1+20%) - ลด 20%: =250 - (250*20%) หรือ =250*(1-20%) 4) สูตรหารเพื่อ “ย้อนกลับหา ก่อนเพิ่ม/ลดเปอร์เซ็นต์” อันนี้มักพลาดเวลาเจอราคาหลังบวก VAT แล้วอยากย้อนกลับ - ถ้า 250 คือ “หลังบวก VAT 7% แล้ว” ราคาก่อน VAT =250/(1+7%) - ถ้า 250 คือ “หลังลด 20% แล้ว” ราคาก่อนลด =250/(1-20%) 5) คิด % ของยอดขายรวม (เหมาะกับตาราง เดือน / ยอดขาย / รวม (%)) ถ้าคุณมีคอลัมน์ “ยอดขาย” เช่นอยู่ที่ C3:C24 และต้องการ % ต่อรวมทั้งหมด - ในแถวแรกของ % (เช่น D3) ใส่: =C3/SUM($C$3:$C$24) - แล้วจัดรูปแบบเป็น Percentage (%) จากนั้นลากลงทั้งคอลัมน์ จุดสำคัญคือใส่ $ เพื่อ “ล็อกช่วงรวม” ไม่ให้เลื่อนตอนลากสูตร 6) เช็กความถูกต้องเร็ว ๆ - ผลรวมของคอลัมน์ % ของยอดขายรวมควรใกล้ 100% (อาจคลาดเล็กน้อยจากการปัดเศษ) - ถ้าคิดแล้วได้ 0 หรือเลขแปลก ๆ ให้ดูว่าเซลล์เป็น “ข้อความ” หรือมีเครื่องหมายคอมมา/เว้นวรรคแปลก ๆ สรุปจำง่าย: อยากได้ “% ของจำนวน” ให้คูณ (%), อยากย้อนกลับ “ก่อนเพิ่ม/ลด” ให้หารด้วย (1±%), และถ้าคิด “% ของยอดขายรวม” ให้เอายอดแต่ละเดือนหารด้วย SUM ของทั้งช่วง แล้วล็อกช่วงด้วย $

Related posts

How to create a budget that actually works
This Method works for me every time! Step by step on how to build a budget to get your bag! Don’t waste anymore time or money trying to figure out why it’s not working, it’s simple! #budget money 💰 #budgets #save your money #embracevulnerability #unfiltered
Skyleigh sroka

Skyleigh sroka

1605 likes

A person's legs and feet on a sidewalk with overlay text 'Mark Klimek Notes Blue Book Part 1', indicating study material for nursing exams.
A page from the 'Blue Book' notes covering nutrition, infant care, and Bell's Palsy, presented in a question-and-answer format.
A page from the 'Blue Book' notes detailing information on men's prostate health (BPH, TURP), bladder treatment, and Foley catheter care.
Mark Klimek Blue Book Part 1
I've got the Blue Book if anyone wants it. I passed my exam on the first try using Mark Klimek and Bootcamp!😁 Tried Archer too, but it was too overwhelming for me and my friends. We all found Bootcamp way more helpful. Let me know if you would like me to post more!! #nursing #nclex #nu
Jam

Jam

411 likes

A woman in purple leggings and a grey sports bra is in a plank position, showcasing her glutes in a gym setting. Overlay text reads "BIG GLUTES +FLAT TUMMY -DEBLOAT- -NUTRITION- -WORKOUTS-" and her username.
This image explains how the StairMaster targets glutes and abs. It details how step climbing and hip extension work the glutes, and how core stability and engagement through movement strengthen the abs, with a woman on a StairMaster.
A 10-minute intense StairMaster warm-up or cooldown routine is outlined, with specific levels and durations. It notes this is not a full workout and suggests using it before or after a main session.
Ultimate Abs & Butt Workout 4 Flat Stomach & BIG🍑s
Dreaming of a small waist and a big, round butt? Trust, you're not alone and I wanna help make that happen for you! Achieving a trim waist and a peachy bum not only boosts confidence but is very much do able! The benefits of strong abs and glutes go far beyond aesthetics. 🍋Toned abs n
Chalie_Baker

Chalie_Baker

1652 likes

#taylorswift #surprise
Cutieeeinpink

Cutieeeinpink

186 likes

A woman in athletic wear poses in a gym mirror, showcasing her glutes. Overlay text reads "HOW TO CARB CYCLE FOR GLUTE GROWTH WITHOUT GAINING TUMMY FAT," introducing the topic.
A close-up of a bowl filled with a meal containing shredded chicken, grains, and sauce. An overlay states, "LEG DAYS eat higher carb higher protein lower fat," illustrating a carb cycling meal.
A salad with leafy greens, avocado, chickpeas, and chicken, alongside a cold beverage. An overlay indicates, "REST DAYS eat low carb high protein moderate fat," showing a meal for rest days.
HOW TO CARB CYCLE : GLUTE GROWTH
if you’re looking to grow your glutes/legs and are concerned with gaining tummy fluff from the higher food intake you might want to consider a carb cycle! First find your macros based on your TDEE (total daily energy expenditure) and then adjust your macros based on that number! Set your ma
Jules

Jules

655 likes

A person from behind is on a stairmaster machine, with text overlaying the image that reads "STAIRMASTER ROUTINE FOR FAT LOSS" and instructions on calculating calories.
A close-up of a stairmaster console with text detailing a 60-minute workout routine, including speeds, duration, frequency, calorie burn, and a progressive plan for beginners.
A person's hand rests on a stairmaster handle, with text explaining weight loss expectations (3500 calories = 1lb) and steps for calculating TDEE and tracking calories for fat loss.
My stairmaster routine 💦🏋️‍♀️
✨STAIRMASTER ROUTINE FOR FAT LOSS✨ •20 minutes on speed 6 for 20 minutes •20 minutes on speed 9 for 20 minutes •20 minutes on speed 7 for 20 minutes *** no rest between: 60 minutes total. 🔁 Repeat this routine 5 days per week *POST weightlifting 🏋️‍♀️ This routine on average burns 500 -
Danielle

Danielle

1753 likes

A hand holds an Apple Watch displaying an 'Update complete' notification, set against a blurred outdoor background. The image highlights the title 'APPLE WATCH Hacks YOU DON'T KNOW'.
A hand holds an Apple Watch showing a tip calculation interface with a 20% tip, total amount, and number of people. The text overlay reads 'CALCULATING TIPS'.
A hand holds an Apple Watch displaying a live camera feed with a dog in the frame and a 3-second timer. The text overlay states 'CAMERA REMOTE', with a blurred dog in the background.
You definitely don’t know these hacks
First: make sure your watch is fully up to date! 📟: Calculating tips has been made easy! All you need to do it put in the total and then you can use the side turn dial to change the percent tip you want. (Ps why is there no calculator emoji) 📷: I have used this so many times. You set your p
Jordaan

Jordaan

1651 likes

This image provides pediatric nursing information on vital signs, infant gross motor skills, physical assessment (fontanels, height/weight, dentition), and infant reflexes (Stepping, Babinski's, Tonic neck, Sucking/Rooting, Palmar, Plantar, Moro).
This image presents maternal newborn nursing concepts including infertility definition and diagnostic procedures, signs of pregnancy (presumptive, probable, positive), expected physiological changes during pregnancy, and calculations for due date, fundal height, and GTPAL.
This image covers maternal newborn nursing topics: supine vena cava syndrome and its prevention, important prenatal lab tests, common discomforts during pregnancy, and guidelines for weight gain and calorie intake during pregnancy and breastfeeding.
📝 Save This for Peds & Maternity Nursing🤰
Studying for NCLEX or a nursing exam? Here are some key points to remember for Pediatrics & Maternity! 📚💉 🌟 Pediatrics 👶 Growth & Development Milestones: ✔️ 6 months – sits with support, babbles ✔️ 12 months – walks with help, says a few words ✔️ 2 years – runs, speaks in 2-word phra
Nurse Radiance

Nurse Radiance

675 likes

Calculating… #fyp #foryou #foryoupage #funny #lmao #lol #humir #comedy #comedian #comedyskit #sketchcomedy #character #acting #voiceacting #relatable #anxiety #laugh #haha #joke
KAL

KAL

66 likes

The ultimate test of our relationship 😮‍💨🎀
BETHANY SIMKO

BETHANY SIMKO

192 likes

A rose gold iPad with an Apple Pencil on a bed, featuring the text 'APPS TO USE TO TAKE NOTES ON IPAD AND TABLET' and 'Swipe'.
An iPad on a stand displaying notes in Notewise, surrounded by a keyboard, pink pen holder, and study materials.
An iPad displaying 'Personal injury' notes in Goodnotes, with a glass of water, laptop, and magazine nearby.
Apps to use to take notes on Ipad and Tablet
Best APPS to use for Ipad and Tablet note taking: 🌸Notewise is compatible with Android 🌸Goodnotes is compatible with IOS 🌸Kilonotes is compatible with both Android and IOS ♡ Planner Suggestions ♡ Pink Digital Planners that are compatible with these apps are available in Bio. #embr
Pretty Planning

Pretty Planning

5037 likes

Transform Your Body: Big Gains Without Excess Fat🍑
As the cold seasons approach, many of you will find yourselves in that familiar phase: the bulking season! It’s that time of year when the leaves fall, and my motivation to pack on muscle rises. But let’s be real—bulking doesn’t mean throwing caution to the wind and indulging in every sugary snack
Chalie_Baker

Chalie_Baker

818 likes

A person in workout attire stands next to text stating "CARBS DON'T MAKE YOU FAT!". Surrounding them are images of Fairlife chocolate milk, pasta with broccoli, bread, white rice, avocado, and ice cream, illustrating various food types.
A graphic titled "What Should I Eat? Foods with High Quality Carbs" displays images of butternut squash, granola, couscous, sweet potatoes, pasta, lentils, oats, cooked rice, and fruit, each with their carbohydrate content per serving.
Text outlines how to calculate carbohydrate needs for weight loss, including formulas for Basal Metabolic Rate (BMR) for men and women. A yellow cartoon character is shown thinking of a croissant.
Carbs are not the enemy!!✋🏼✨🩵 Weight loss With Carb
I wanted to talk about something that's been on my mind lately—carbohydrates. It seems like carbs have gotten a bad reputation, especially when it comes to weight loss. There's this belief out there that if you want to shed pounds, you have to avoid carbs at all costs. But let me tell y
Chalie_Baker

Chalie_Baker

2028 likes

A comprehensive guide titled 'Dosage Calculation' detailing various medication calculation methods. It includes sections on conversions, rounding rules, liquid dosages, injection dosages, dimensional analysis for tablets, weight-based dosages, IV flow rate with a pump, and manual IV infusions, each with example problems and solutions.
Dosage Calculation - Dimensional Analysis
Dosage calculations aren’t optional—they’re essential. Medication errors remain one of the most common issues in healthcare, and strong calculation skills are key to preventing them. That’s why mastering measurement conversions and dimensional analysis is non-negotiable for nursing students. Most
Student Nursing Essentials

Student Nursing Essentials

1259 likes

Calculate Your Down Payment On A 🚗
@Welcome Baddies Calculating your down payment for a car using a specific percentage of the total vehicle cost allows for a structured approach to budgeting and affords the benefit of securing more favorable financing terms, potentially resulting in lower monthly payments and reduced interest
Welcome Baddies

Welcome Baddies

426 likes

This image provides a guide on how to calculate engagement rate and average engagement per post for social media, including the formulas and definitions for total engagements, total followers, and number of posts.
This image displays an example media kit for an influencer named Nyla Green, detailing her social media follower counts, demographics, services offered, audience interests, and contact information, alongside a photo of her.
This image presents a glossary of terms relevant to influencers, defining concepts such as Affiliate Program, Collaboration, Gifted PR, Media Kit, and PR List.
Wanna be an Influencer? Part 3 of 3
Just a mom & previously clueless micro influencer sharing- A little while ago I wrote an e-guide with focused on PR & brand collaborations. I’ll be the first to tell you that I’m not an expert but at that time I was posting consistently had such momentum going…I honestly didn’t have any
AlejandraSpooks

AlejandraSpooks

120 likes

A famous singer falls in love with a country girl #movie #film #fyp #love
movie

movie

60 likes

Two halves of a red grapefruit are displayed on a wooden cutting board. Overlaying the image is text that reads "LOSE WEIGHT WHILE EATING How to structure your diet*" in yellow and white fonts.
A white background with black text titled "UNDERSTANDING YOUR MACROS." The text explains that macronutrients (carbohydrates, proteins, fats) are the building blocks of diet, each serving a unique purpose for energy, muscle, and hormone production, essential for weight loss.
A white background with black text titled "HOW TO DETERMINE YOUR MACROS." It outlines steps for calculating macros: determining caloric needs, setting macro ratios (e.g., 40% carbs, 35% protein, 25% fats for weight loss), and adjusting based on results.
How to Eat to Lose Lbs: Diet for Maximum Fat Burn🔥
Embarking on a weight loss journey can be overwhelming, especially when it comes to diet. There’s so much conflicting information out there—low carb, high protein, intermittent fasting, clean eating—the list goes on. But the truth is, successful weight loss isn’t about depriving yourself or jumping
Chalie_Baker

Chalie_Baker

1188 likes

At least I have my planner 😁
#stressed #stressedout #student #finals #studying
Byst

Byst

57 likes

Calculating your calorie deficit!
This is how I calculate my deficit everyday while I aim to lose weight! ☺️ If you have any questions, let me know. Good luck! 🧘‍♀️❤️ #caloriedeficitwins #caloriecouting #calorietracking #summerbod #bodytransformation
notyourblonde

notyourblonde

621 likes

Gucci for Mother’s Day 😂
The Gucci backpack is adorable… 3 pigs for 3 kid. How thoughtful… but reseller brain immediately started calculating how many thrift trips a Goodwill gift card could fund 😭💅 Only resellers will understand this logic 😂 #reseller #thrifter #goodwillfinds #gucci #resellerlife
retail therapy

retail therapy

177 likes

Feel & Look 🔥HOT🔥 By Summer: (It’s 4 Weeks Away)👙☀️
Example 4-Week ✨Weight lifting/ Gym✨ Plan Weekly Structure: Day 1: Glutes + Cardio Day 2: Upper Body + Cardio Day 3: Legs + Cardio Day 4: Upper Body + Cardio Day 5: Glutes + Cardio Day 6: Cardio/Running/HIIT Day 7: Active Recovery Repeat every week, repeated every month ❤️ ———————
Chalie_Baker

Chalie_Baker

1344 likes

#LIVEIncentiveProgram #LIVEMonetization #PaidPartnership
Nia

Nia

6 likes

A page from 'DRUG CALCULATIONS' appendix, detailing tablet dosage formulas (formula and ratio methods) with an example, and drip rate calculations for macro and micro drips, including formulas and notes.
This page provides an example for drip rate calculation, followed by medication dosage formulas for intravenous and intramuscular injections using both formula and ratio methods, with examples for morphine and insulin.
This page continues with a morphine dosage example, then presents calculations for volumetric pumps (volume/dose per hour) and dose in µg/min, showing both formula and ratio methods for each.
💊 Struggling with Dosage Calculations? I Got You!💉
Dosage calculations can be one of the trickiest parts of nursing school, but don’t worry—I’ve got something to help! I’ve found a PDF guide that breaks down formulas, step-by-step examples, and practice problems to make med math SO much easier. Let’s make med math stress-free and build confidenc
Nurse Radiance

Nurse Radiance

555 likes

A nursing education graphic titled 'Med Math: Calculating IV Flow Rates' explains how to determine IV pump settings. It covers key considerations like rounding and provides two examples for calculating mL/hr, including a problem with military time conversion and a military time chart.
Med Math for Nursing (Part 2)
Yall really seemed to enjoy my first med math post! So here’s another topic we covered a lot. Literally 50% of both of my med math exams were problems like this. Also a little update: I got 100% on my second med math exam! So now I can pass meds ☺️ If any problems or topics are bothering yo
MonicaBSN

MonicaBSN

1816 likes

A Scorpio Venus mood board featuring women in black and red leather and lace outfits, a velvet dress, and a graphic defining Scorpio traits like power, confidence, and mystery.
A Scorpio-themed mood board with women in dark, mysterious makeup, black lace stockings, black dresses, and a cross necklace, emphasizing powerful and cleansing water imagery.
An edgy Scorpio mood board showcasing women in black leather outfits, studded boots, lace tights, a spiderweb top, and a woman with a headscarf, reflecting a 'notice everything' attitude.
how to dress: scorpio venus 🔮
if you have a scorpio venus, you’re automatically giving femme fatal💋 scorpio is ruled by both mars (the planet of war, motivation & aggression) and pluto (the planet of death & rebirth, transformation & subconscious) having these planets influence your venus, which determines ALL of
Emma Kathleen

Emma Kathleen

332 likes

#reading #romancebookrecs #romancereader #bookworm #romancebooks
DangerouslyDarkBookBoyfriends

DangerouslyDarkBookBoyfriends

44 likes

The image displays multiple stacks of US $100 bills, each bundled with a strap indicating $10,000. The text "HOW TO BUDGET WISELY" is overlaid at the top, visually representing financial planning and savings discussed in the article.
HOW TO BUDGET WISELY and stick to it
Creating a budget is one of the most effective ways to save money, but sticking to it can be challenging. Let’s dive deep into how you can budget wisely and ensure you stay on track. Understand Your Income and Expenses 1. Calculate Your Monthly Income Start by determining your total monthly
Kaliania

Kaliania

358 likes

Really save money🌸
I am moving out in a few weeks, I’m 18 years old. I just bought my first car. Here are the things that genuinely helped me to save my money, read through this if you want to learn as well! First tip: I used a cash stuffing binder, I have it linked in my storefront in my bio! it’s pink and it’s
Shay

Shay

837 likes

#movie #edit #foryou #fyp
lovelittlelee

lovelittlelee

1 like

Concrete quantities for slab on metal deck , simplified. ✔️ 📏 #construction #concrete #fyp #viral #womeninconstruction
Ghina_abbas

Ghina_abbas

1 like

An open Bible with handwritten notes and highlights on Proverbs 22-26, covering topics like money, raising children, and mockers. A Starbucks cup is placed on the Bible.
A close-up of Proverbs 22 in an open Bible, showing highlighted verses and notes about wealth, raising children, and disciplining the foolish.
Proverbs 22-23 in an open Bible with highlights and notes on choosing friends wisely, avoiding debt, and not overworking.
Proverbs 22-26 Bible study 🌸
Today I studied proverbs 22-26. I recommend you read the Bible on your own time & gain understanding/discernment. Here’s what I learned: • money means nothing if you don’t have favor from God. Rich or poor we are all the same. • teach/grow your child in Gods ways • mocker= someone who a
Jocelyn G.

Jocelyn G.

101 likes

See more