|
CURSOS | SOLICITA INFORMACIÓN
|
|
|
Solicite información sin compromiso
| |
 |
|
Excel Magic Trick 167p1 IF function formula: 12 Examples!
 |
||
Part 1. See 12 different examples of how to use the IF function. This video starts with IF function basics and then shows 12 different examples of how the IF function can be used in formulas. Also see these functions: AND, OR, SUM, AVEARAGE, STDEVP, and VLOOKUP.See how to use the IF function to put:1 of 2 numbers in a cell or formula.1 of 2 words in a cell or formula.1 of 2 text strings in a cell or formula.1 of 2 formulas in a cell or formula.1 of 2 functions in a cell or formula.1 of 2 cell ranges in a cell or formula.How to have more than one IF (Nested IF Ifs).When to switch to the VLOOKUP function.How to build multiple criteria formulas with the IF function.How to use the AND function with the IF function.How to use the OR function with the IF function.Excel If statementExcel Magic Trick 165p2 MACRO Advanced Filter Extract B-daysOther amazing videos at YouTube: Excel Trick, Making a Gantt Chart with Excel, Recording Macros - Excel 2003, VLOOKUP in Excel 2007.
Canal: Science & Technology
Añadido: November 30, 1999 at 12:00 am
Autor: ExcelIsFun
Duración: 10:31
Puntuación: 4.7763977
Reproducciones: 166606
Etiquetas: Excel IF function formula statement AND OR SUM AVERAGE VLOOKUP Mike Gel Girvin Highline Community College
Comentarios
|
ExcelIsFun (November 30, 1999 at 12:00 am)
@skydive911 , cool!
skydive911 (November 30, 1999 at 12:00 am)
@ExcelIsFun I liked it very much indeed! In fact... until days ago i thought Excel was stupid complicated and useless but now you got me into the magic!
ExcelIsFun (November 30, 1999 at 12:00 am)
@skydive911 , You are welcome! Did you like the video?
skydive911 (November 30, 1999 at 12:00 am)
@ExcelIsFun Wow Wow Wow! That is just AWESOME!I appreciate that so much! You are an ACE Sir!Thank you so very much! Subbed.
ExcelIsFun (November 30, 1999 at 12:00 am)
@skydive911 , check out latest video I just made:Excel Magic Trick 863: If Sat or Sun, Multiply by 15, Any Other Day Use 14 WEEKDAY & IF Functionsyoutube [dot] com/watch?v=m82C9uc4Bm0Formulas like this will work:=IF(WEEKDAY(A5,2)>5,B5*$C$1,B5*$C$2)or=B5*((WEEKDAY(A5,2)>5)+14)
skydive911 (November 30, 1999 at 12:00 am)
Hi! I was wondering if you also knew a function to do something like:If Day = Saturday or Sunday -> Multiply amount of houres with factor 15If Not (any other day) -> Multiply amount of houres with factor 14.Could you please help me out? Help would be very much appreciated!!
ExcelIsFun (November 30, 1999 at 12:00 am)
@llnicholsii , yes, post questions to THE best Excel question site:mrexcel [dot] com/forum
llnicholsii (November 30, 1999 at 12:00 am)
Excellent video!!! Is there a way to have two IF logical functions with with two different true responses and two different false responses?E.g. IF(AND(A1=B1,"Ok",IF(A1<0,"-1",IF(B1<0,"+1,"Bad")))
nikhilkhandelwal0311 (November 30, 1999 at 12:00 am)
@ExcelIsFun please give formula for this condition
ExcelIsFun (November 30, 1999 at 12:00 am)
You may need VBA for that. Post Q to:mrexcel [dot] com/forum
|