La periodista y candidata al Gobierno Regional de Áncash, en Perú, Susy Aponte Polo, fue asesinada a balazos durante una actividad de campaña en Caraz.
Imagina explicarle a alguien hoy que en 2002 un director compró los derechos de una película de artes marciales de 1976 (Tiger and Crane Fists), usó el CGI de la época para borrar al protagonista original, se metió él mismo en el metraje y redobló TODOS los personajes con voces ridículas.
Eso hizo Steve Oedekerk para crear KUNG POW, la cumbre absoluta del cine absurdo. Mezcló escenas setenteras reales con tomas nuevas en un croma, peleó contra una vaca experta en karate hecha digitalmente y nos dejó frases míticas que 24 años después seguimos repitiendo.
Una genialidad técnica y humorística incomprendida en su momento que hoy es una obra de culto indispensable. 🎬🚬🖐️
#KungPow
🚀 Excel Formulas Fundamentals — Part 6
🧠 Logical Functions IF, AND, OR, IFERROR with Real-World Examples*
Logical functions help Excel make decisions based on conditions.
*📌 These functions are heavily used in:*
Data Analysis
Finance
HR Reporting
Sales Dashboards
Business Rules
*🎯 1. IF Function*
The IF function checks a condition and returns one value if TRUE and another if FALSE.
*Syntax* `=IF(condition,value_if_true,value_if_false)`
*Example: Pass or Fail*
Marks 75
*Formula:* `=IF(A2>=50,"Pass","Fail")`
*Result:* Pass
*Business Example*
Sales 120000
*Formula:* `=IF(A2>=100000,"Target Achieved","Target Missed")`
*🔀 2. Nested IF Function*
Used when multiple conditions need to be checked.
*Example: Student Grades*
`=IF(B2>=90,"A",IF(B2>=75,"B",IF(B2>=50,"C","Fail")))`
*Result*
Marks Grade
95 A
80 B
60 C
40 Fail
*📌 Useful for:*
Employee ratings
Performance categories
Bonus calculations
*🔗 3. AND Function*
Returns TRUE only if ALL conditions are true.
*Syntax* `=AND(condition1,condition2)`
*Example* Student must pass both subjects.
`=AND(A2>=50,B2>=50)`
*Combined with IF*
`=IF(AND(A2>=50,B2>=50),"Pass","Fail")`
*Example*
Math Science Result
60 70 Pass
60 40 Fail
*🔓 4. OR Function*
Returns TRUE if ANY condition is true.
*Syntax* `=OR(condition1,condition2)`
*Example*
`=OR(A2>=90,B2>=90)`
*Combined with IF*
`=IF(OR(A2>=90,B2>=90),"Bonus Eligible","No Bonus")`
*Example*
Product A Product B Bonus
95 40 Eligible
60 70 Not Eligible
*⚠️ 5. IFERROR Function*
One of the most important Excel functions. Used to handle errors gracefully.
*Without IFERROR*
`=A2/B2`
If B2 is zero: #DIV/0!
*With IFERROR*
`=IFERROR(A2/B2,"Invalid Data")`
*Result:* Invalid Data
*📌 Makes reports cleaner and more professional.*
*🔍 6. Common Excel Errors*
Error Meaning
#DIV/0! Division by zero
#N/A Value not found
#VALUE! Wrong data type
#REF! Invalid reference
#NAME? Formula name error
*Best Practice* Wrap critical formulas with:
`=IFERROR(formula,"Error")`
*💰 7. Real-World Scenario: Sales Bonus*
*Rule* Sales ≥ ₹100,000 → Bonus, Otherwise → No Bonus
*Formula:* `=IF(B2>=100000,"Bonus","No Bonus")`
*👨💼 8. Real-World Scenario: Employee Performance*
*Rule* Score ≥ 90 → Excellent, Score ≥ 75 → Good, Score ≥ 50 → Average, Else → Needs Improvement
*Formula:* `=IF(B2>=90,"Excellent",IF(B2>=75,"Good",IF(B2>=50,"Average","Needs Improvement")))`
*🏦 9. Real-World Scenario: Loan Eligibility*
*Conditions* Salary ≥ ₹50,000, Experience ≥ 2 years
*Formula:* `=IF(AND(B2>=50000,C2>=2),"Eligible","Not Eligible")`
*🛒 10. Real-World Scenario: Discount Eligibility*
*Conditions* Purchase Amount > ₹10,000 OR Premium Customer
*Formula:* `=IF(OR(B2>10000,C2="Yes"),"Discount","No Discount")`
*🎯 Mini Practice Project*
Create: Employee_Performance.xlsx
*Data*
Employee Score
Rahul 95
Priya 80
Amit 65
Neha 40
*Tasks*
✅ Create Performance Rating
`=IF(B2>=90,"Excellent",IF(B2>=75,"Good",IF(B2>=50,"Average","Poor")))`
✅ Create Bonus Eligibility
`=IF(B2>=80,"Bonus","No Bonus")`
✅ Use IFERROR
`=IFERROR(A2/B2,"Error")`
*🏆 End of Part 6*
After completing this lesson, you should be able to:
✅ Use IF() confidently
✅ Combine IF with AND() and OR()
✅ Handle errors using IFERROR()
✅ Create grading systems and bonus calculations
✅ Build business rules using logical functions
➡️ Next Part: Date & Time Functions TODAY, NOW, DATE, YEAR, MONTH, DAY, DATEDIF, NETWORKDAYS used in real business reporting 🚀📊📅
➡️ *Double Tap ❤️ For Part-7*
🤯 EN 1913, ILS ENSEIGNAIENT DÉJÀ COMMENT CONTRÔLER LE MAGNÉTISME HUMAIN
Ces vieux articles de journaux expliquent que chaque personne possède une « batterie vitale » — une véritable force magnétique à l’intérieur du corps qui peut être dirigée pour augmenter la force physique, le pouvoir mental, le charisme et même l’influence émotionnelle.
Ils l’appelaient le « Magnétisme Personnel ».
Les textes détaillent comment conserver cette énergie, comment la diriger, et mettent même en garde contre le fait de la « gaspiller ». Il existait aussi des entreprises qui vendaient des boucliers et ceintures magnétiques pour protéger et amplifier cette force.
Il y a plus de 110 ans, on parlait déjà de champs énergétiques humains, d’électricité vitale et de la manière de les utiliser consciemment.
Et si ils avaient raison depuis le début ?
Que pensez-vous — simple pseudoscience ancienne… ou savoir perdu ? 👇
GÖRÜNTÜLER YAPAY ZEKA DEĞİLDİR
😏🤫
ABD uzaylı ve UFO görüntüleri belgelerini açıkladıktan sonra oraya çıkan görüntüler.
Kendim bizzat Diyar Diyar gezdim araştırdım görüntüleri bizzat sizin için canımı tehlikeye atarak çektim.
Elim de daha NASA ABD CIA FBI Ajanlarının sakladığı belgeler var. Yakında paylaşırım.
Hala bu görüntülerin gerçek olduğuna inanan bir kitle var. İnanmayanlar da paylaşarak etkileşime neden oluyor.