Excel Magic Trick 863: If Sat or Sun, Multiply by 15, Any Other Day Use 14 WEEKDAY & IF Functions

Download from: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn About
1. WEEKDAY Function to determine what day of the week it is
2. Formula to multiply amount by 15 if it is Saturday or Sunday and 14 if it is any other day of the week: Formula that used WEEKDAY and IF Functions
3. See Boolean Formula that is an alternative to the IF Function.

Category:

Education

Tags:

• Excel
• 2003
• 2010
• 2007
• Mike
• Girvin
• excelisfun
• Highline
• Community
• College
• WEEKDAY
• Function
• to
• determine
• what
• day
• of
• the
• week
• it
• is
• Formula
• multiply
• amount
• by
• 15
• if
• Saturday
• or
• Sunday
• and
• 14
• any
• other
• week:
• that
• used
• IF
• Functions
• Boolean
• an
• alternative

[jimbij007]

hi ,

1:58 .. I am not getting this drop down in my excel.. Could you please help me on this.. thanks

[ExcelIsFun]

@jimbij007 , that means you do not have Excel 2010. You must have Excel 2007 or 2003...

[jimbij007]

@ExcelIsFun yeah i do.. so there is no option for the same in older versions?

[ExcelIsFun]

@jimbij007 , none whatsoever.

[elphau]

really like your videos. still can't believe you're doing this for free.

[ExcelIsFun]

@elphau , our job as humans is to make the world a better place and have fun, so this is perfect for me!

[ExcelIsFun]

@Dhawan1988 , Okay!

[ExcelIsFun]

@krn14242 , cool! Thanks!

[krn14242]

Great trick Mike. Like the "esoteric" version also, although would ultimately go with the logical IF statement.  Thanks.