Functions Archives | How To Excel

4 Ways to Remove Unwanted Space Characters

by John | Sep 27, 2018 | Functions, Power Query, Tutorials, VBA | 2 |

Learn how to remove unwanted space characters from text data in Excel using various methods.

The Ultimate Guide To VLOOKUP

by John | Sep 11, 2017 | Functions | 0 |

The VLOOKUP function allows you to search a value in the left most column of a range and return the corresponding value in a column to the right. The search is vertical from top to bottom and in fact, the “V” in VLOOKUP stands for vertical.

COUNTIFS function

by John | Jul 7, 2016 | Math | 0 |

This function will conditionally count items in a range based on given criteria. Syntax COUNTIFS(Range 1, Criteria 1, Range 2, Criteria 2,…) Range 1 (required) – This is the range to which the first criteria is...

INT function

by John | Jun 26, 2016 | Math | 0 |

This function will rounds a number down to the nearest integer. Syntax INT(Number) Number (required) – This is the number you want to round down to the nearest integer. Example In this example find the round down a few...

SUMIFS function

by John | Jun 19, 2016 | Math | 0 |

This function will conditionally sum up numbers in a range based on given criteria. Syntax SUMIFS(Sum Range, Range 1, Criteria 1, Range 2, Criteria 2,…) Sum Range (required) – This is the range of numbers to sum....

ABS function

by John | Jun 17, 2016 | Math | 0 |

This function will return the absolute value of a number. The absolute value is the “positive” part of a number. Syntax ABS(Number) Number (required) – This is the number you want to find the absolute value of....

PROPER function

by John | Jun 5, 2016 | Text | 0 |

This function will function will capitalize the first letter of each word. Syntax PROPER(Text) Text (required) – This is the text string which you want to capitalize the first letter of each word. Example In this example...

UPPER function

by John | Jun 5, 2016 | Text | 0 |

This function will convert text to all uppercase letters. Syntax UPPER(Text) Text (required) – This is the text string you want to turn into all uppercase letters. Example In this example we convert some text into...