How To: Use 'If' in Microsoft Excel formulas

Use 'If' in Microsoft Excel formulas

Learn some more advanced formula uses in Microsoft Excel including the "IF" statement. For example, "IF someone earned over $200 then charge them $20... otherwise charge them $40."

Want to master Microsoft Excel and take your work-from-home job prospects to the next level? Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more.

Buy Now (97% off) >

Our Best Phone Hacks

Gadget Hacks' tips — delivered daily.

1 Comment

I have this formula =AVERAGE(Sheet1!Z2:Z2356) but I need it to look at another cell for the month and use the if statement

Share Your Thoughts

  • Hot
  • Latest