Lemon8Lifestyle community

Automatically translated.View original post

Excel Data Mast
Excel Data Mast

25.2K followers

Follow
Follow
Follow

26 saved
30

📊 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

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

672 likes

Advice on starting a junk journal
Junk journaling should not be stressful! Start with what you have including any glue and notebook to get started. You can establish a theme or style as you go if you'd like, but don't hold back from trying because of your perfectionism. Some spreads will look better than others, and that&#3
Jem and Cozy

Jem and Cozy

38 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

654 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

1749 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

814 likes

Dosage calculation
Cheat sheet for dosage cal #studyhardplayharder #dosagecalc #nclex #nursingschool #nursingstudents
🩺 Nurse Val🇺🇸

🩺 Nurse Val🇺🇸

491 likes

Share this with someone who doesn’t know how to get their calorie deficit #fyp #greenscreen
Salimah Abdul

Salimah Abdul

31 likes

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

1596 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

1650 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 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

2026 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

617 likes

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

KAL

240 likes

A laptop displaying academic text about linguistics, with an overlay stating 'BEDTIME STUDY SESSION FOR STRAIGHT A'S' on the keyboard.
A bedroom scene with a bed and window, featuring text overlays explaining 'WHY? Sleep boosts memory, brain function, and learning info retention magic'.
A phone in a holder above a bed, showing a scientific abstract on sleep deprivation, with text overlays 'SCIENCE SAYS Sleep helps reduce distractions, Strengthens neural connections, Improves long-term recall'.
How I study before bed effectively
Bedtime study session for straight As. Yep, turns out your brain loves a bedtime study session. Research shows that studying right before sleep actually helps your brain retain more info (especially if you’re reviewing with active recall). Basically: your brain does some ✨deep file organizing
Meredith Jao

Meredith Jao

51 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

554 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

1187 likes

A large grocery haul from BJ's, including various snacks, cereals, and pantry items, spread across a floor with a hand in the foreground. The total spent is displayed as $418.32.
A selection of dairy and frozen items from a grocery haul, including ice cream bars, sour cream, coffee creamers, and whipping cream, displayed on a kitchen counter.
Various frozen and refrigerated grocery items, such as mozzarella sticks, butter, cream cheese, frozen pizza, beef patties, and mac & cheese bites, on a kitchen counter.
$418.32 spent at BJS 👀
BJ’s run 🛒 My budget was $400. I was calculating my total with coupons as I shopped and it wasn’t anywhere near $500. At checkout, prices rang up differently (possibly different from online) and I was also charged extra for one item. Final total came to $418.32. Things happen…only went over $1
Modestmommy

Modestmommy

730 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

I’m passing this down to a nurse or future nurse bestie that will be the best she can be💕
You know if nothing else, I want to see my people do well. I am a real nursing bestie and if I find some info, I’m passing it along. Someone gave this to me and so I’m passing it to yall so you have it for reference. Save for later. Hope this helps you and provides reference for your growth 💕🥰🥂 #n
AKIMNEVERSETTLES11

AKIMNEVERSETTLES11

1325 likes

A woman with braided hair and beads sits in a car, looking at the camera. Text overlays indicate her starting weight of 260lbs, representing the 'before' stage of her weight loss journey.
How I went from 260lbs to 225lbs🥹
Calorie deficit will save you🤌🏾 - Understand your caloric needs by calculating how many calories you need to maintain your weight based on your age, sex, weight, height, and activity level. - Create a deficit by aiming for about 500 to 1000 calories less than your maintenance level each day. T
Jada 🧚🏽‍♀️

Jada 🧚🏽‍♀️

750 likes

Two interior decorating textbooks (Volume 1 and Volume 2) and a notebook titled "THE PLANS I HAVE FOR YOU" are displayed on a rug, illustrating the life of an interior decorator student.
A clear calculator with pink and peach-colored round buttons rests on a light-colored surface, symbolizing the cost calculation aspect of interior design.
A digital rendering of a luxurious bedroom design features a black tufted bed, dark green accent wall, gold light fixtures, and a white shaggy rug, showcasing a concept brought to life.
Life as an INTERIOR DECORATOR STUDENT
I felt lead my God to pursue this dream after I asked for a sign and was immediately alarmed by a voice shouting YES ! It was all the confirmation I needed . And one of the best decisions he has made for me at this time in my life What does this look like so far? It looks like calculating co
Jenny Brittany

Jenny Brittany

20 likes

Small creators can get paid to make videos talking about going Live on TikTok!! #LIVEIncentiveProgram #LIVEStory #PaidPartnership #golive #fyp
India Christin

India Christin

5 likes

#PaidPartnership #LIVEGrowFollowers #LIVEIncentiveProgram #fyp
brianda ramirez

brianda ramirez

0 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

425 likes

This image displays HESI dosage calculation exam questions. It includes a question about the Parkland formula for burn fluid needs, with the correct answer highlighted, and a question on calculating octreotide dosage (250mcg from 1000mcg/ml), with the answer 0.25 ml highlighted.
This image continues with HESI dosage calculation questions. It features a question on calculating octreotide volume using the Desired/Have formula, an infusion rate calculation for a medication (500 mcg/minute, 0.2 grams/100 ml) with 30 ml/hour highlighted, and a partial question about acetaminophen elixir concentration.
This image presents more HESI dosage calculation questions. It shows the correct acetaminophen elixir concentration as 500 mg/15 ml, highlights the significance of correct infusion rates for patient safety, and includes calculations for dopamine infusion (2.7 mcg/kg/minute) and IV fluid administration (125 mL/hr).
HESI DOSAGE CALCULATIONS ACTUAL EXAM 2025/2026
HESI DOSAGE CALCULATIONS ACTUAL EXAM 2025/2026 -GUARANTEED PASS!!
Lemon367443437826

Lemon367443437826

1 like

#LIVEIncentiveProgram #LIVEMonetization #PaidPartnership #fyp #creatorsearchinsights
Nia

Nia

8 likes

A study guide for future nurses covering basic medical terminology, dosage calculation formulas, infusion rates, weight and mass conversions, vital signs, anatomy, physiology, and medication study prompts.
A blank weekly planner template with sections for each day of the week, along with dedicated spaces for important tasks, exams, and general notes.
A pharmacology study template with fields to identify the system involved, generic and brand names, drug class, mechanism of action, therapeutic uses, side effects, nursing considerations, contraindications, routes of administration, patient education, and dose.
Starting nursing school ?? 🫀🩺
Click the pics include 📚what to study before nursing 🗓️weekly planner 💊pharmacology 🩺 anatomy anatomy/ structural to know 🧠medical terminology #nursingschooltips #nursingstudent #notestips #fyp #viral
Vanessaaa

Vanessaaa

1209 likes

Always try our best !!! #wristle #beads #diy #baggame #keychain
chrisdomi

chrisdomi

1 like

Calculating the exact moment to knock…
everything off the shelf🤓😼🐾 #meetmyfurbaby #lemon8challenge #lemon8creator #catsoflemon8 #lemon8diary #fashionfinds #dayinmylife #ai #petsoflemon8 #storytime @Lemon8 Pets Upper West Side
Olive Pawlovsky

Olive Pawlovsky

17 likes

🌄 The Journey XV — From Arrival at the Concord Exp
🌄 The Journey XV — From Arrival at the Concord Expanse to The Unbidden Thread 🌄 They entered seeking agreement... but discovered something deeper: alignment can’t be voted into existence. At the Concord Expanse, every move mattered. Not just power, but timing, trust, and how each action affe
AlfredoLevelUp

AlfredoLevelUp

3 likes

A red bag with the title 'Dosage Calculations: Weight based' in white and red text overlay, indicating the topic of the article.
Dosage Calculations:Weight based
Weight-based dosing is commonly used in pediatrics, critical care, and anesthesia. Let’s break it down into 3 simple steps with an easy example! 📌 Example: 🔹 Order: 0.5 mg/kg of a drug 🔹 Patient weight: 79 lbs 🔹 Available concentration: 10 mg/mL Step 1️⃣: Convert Pounds to Kilograms &#x
Taylor Price RN, BSN

Taylor Price RN, BSN

595 likes

A person in a black sports bra and shorts, showing their toned midsection, with text overlay "HOW TO LOOSE 10LBS OF PURE FAT w/o loosing muscles."
A side-by-side comparison of a person's body profile, showing a before and after transformation, with text overlay "HOW I LOST 10 LBS OF PURE FAT."
A Bodyspec scan summary showing body composition results, including initial 28.0% and final 19.1% total body fat, along with a body fat percentile chart.
The 1 exercise you need to drop 10lbs of pure fat
📍Starting Point: I’ve always been on the smaller side at 116lbs, but my body fat percentage (28% measured by Bodyspec) showed I had room to tone up. With my wedding coming up, I wanted to focus on body recomposition—losing fat while keeping muscle—to look and feel my best. Here’s what worked fo
Monika

Monika

702 likes

9 key points to building an emergency fund
Emergency funds are a crucial aspect of financial planning. They provide a safety net to cover unexpected expenses or income disruptions, such as medical emergencies, job loss, or car repairs. Building an emergency fund requires discipline and commitment, but it can provide peace of mind and financ
Investingashley

Investingashley

20 likes

A person in navy blue scrubs and a light-colored long-sleeve shirt takes a mirror selfie, with text overlayed that reads 'What I Do In A Day As A Travel Phlebotomist'.
A hand holds a clear plastic bag containing several blood sample tubes, some labeled, inside a car with a steering wheel visible. Text reads 'I'm basically a vampire on wheels Just driving around collecting blood'.
A hand holds a can of 'ASPIRE Healthy Energy' drink, dark cherry lime flavor, in a car with a fuzzy steering wheel cover. Text describes the drink's energy benefits.
Vampire On Wheels 🩸
I recently became a travel phlebotomist and I really like it. In terms of "I recently" starting this job, I started last Monday, and I've already met about 30 patients. In order to set myself up properly, I'm trying to figure out my route. Honestly, it's a hassle, but I'
Chesca

Chesca

254 likes

See more