How to use excel FIXED function

Excel version in which Fixed function can work: Excel Fixed function is a built-in function in Excel, This function will work in Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Mobile Excel for Android phones. About FIXED function in excel: In Excel, FIXED function rounds the number into a specified number of decimals with or without commas…

Continue Reading

Proper in excel: How to use PROPER worksheet function

Excel version in which Proper function can work: PROPER in excel functions will work in Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Mobile Excel for Android phones. About function Proper in excel: PROPER function in excel converts all texts to propercase. If the characters are other than letters , they are unaffected by using this function. Syntax…

Continue Reading

Excel Change case functions- UPPER & LOWER

Excel Version in which UPPER & LOWER functions can work: Excel Change case functions will work in Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Mobile Excel for Android phones. About Excel Change case functions- UPPER & LOWER: UPPER function in excel converts all texts to Uppercase. If the characters are other than letters , they are unaffected…

Continue Reading

Excel XOR function

Excel Version in which XOR function can work: Excel XOR function will work in Excel 2016 Excel 2013 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Mobile Excel for Android phones. About Excel XOR function: XOR function is familiar for those who know the programming knowledge. XOR checks the logical values or conditions and returns TRUE if when number of TRUE inputs are odd and returns when…

Continue Reading

How to use excel IFS function

Excel Version in which IFS function can work: Excel IFS function will work in Excel 2016, Excel Online, Excel for Android tablets, Excel Mobile, Excel for Android phones. About excel IFS function: Excel IFS function checks multiple condition and returns value for first TRUE condition. IFS function can be used instead of using nested if function to check multiple if condition in one formula. This makes formula easy to understand, you can enter up to 127 conditions in one formula.…

Continue Reading

How to use Excel AND Function (as Worksheet Function)

Excel Version in which AND function can work: AND function will work in Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Starter Excel Mobile Excel for Android phones. About AND function: AND function is a logical function which will test the multiple conditions. This function will check for multiple conditions and returns TRUE if all conditions are true. Up to…

Continue Reading

MID function in excel worksheet

Excel Version in which MID function can work: MID function will work in Excel 2016, Excel 2013, and Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, and Excel 2000. About MID function: MID worksheet function extracts specified number of letters from a word. This is a built in function in excel that is categorized as text function. It can be used as a worksheet function and VBA function in macro code that is entered through the…

Continue Reading

Accessing ribbon by using your keyboard

At first glance you may think that the accessing Ribbon is completely Mouse- centric. After all, the commands don't display the traditional underlined letter to indicate the Alt +keystrokes.  But in fact, the Ribbon is very keyboard friendly. The trick is to press the alt key to display the pop-up key tips. Each Ribbon control has a letter that you type to issue the command. Accessing ribbon by using your keyboard Below figure  shows  how the home tab looks  after…

Continue Reading

IF with OR formula for multiple logical tests.

 How to use IF with OR function..? In our previous post IF with AND formula for multiple logical tests is explained with the example. In this post we can understand if with or formula. Instead of using AND function, we can use OR function for testing multiple logical tests to give the results. OR Function: In OR logic, different logical test can be done. This function will check all conditions and returns TRUE if any condition is correct and FALSE if…

Continue Reading

IF with AND formula for multiple logical tests.

How to use IF with AND function..? In our previous post IF function and nested IF function is explained with the example. Similarly, instead of using Nested IF function IF with AND formula can be used for testing multiple logical tests to give the results. AND Function: In AND logic, different logical test can be done. This function will check all conditions and returns TRUE if all are correct and FALSE if any of the logical test fails. In above example…

Continue Reading
Close Menu
×

Cart