Help on IF Function on Excel?

Answer The IF function returns one value if a condition you specify evaluates to TRUE, and another value if it evaluates to FALSE. Use IF to conduct conditional tests on values and formulas. The basic s... Read More »

Top Q&A For: Help on IF Function on Excel

Search function in excel alongside of a time/date function?

dont worry about the AM and PM....the Am and PM are only formatting....they arent really part of the number or just need to check if your times go past midnight...and add 1 if it i... Read More »

Excel,how do i key in a function to fixed staff off's day on my excel sheet?

If you have the dates, You can use the weekday function to determine what day it is. Next you create some fancy compound formula like=IF(OR(WEEKDAY(A1,2)=1,WEEKDAY(A1,2)=7…

How to Use the Lookup Function in Excel?

Whenever you keep track of anything with spreadsheets, there'll come a time when you want to find information without having to scroll through a list. That's when the LOOKUP function can be useful.... Read More »

How to Use Summation Function in Excel?

The Excel spreadsheet program has many different ways to make calculations easier. When you use Excel, you can toss your calculator aside, because the various functions can do all of the hard work ... Read More »