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 the Inverse Log Function in Excel?

A logarithm is the exponent of a mathematical equation. For example, in base 2, log 3 = 8. The inverse logarithm expresses that relationship as 2 raised to the third power equals 8. Excel uses this... Read More »