Excel Functions & Formulas
How to Use IF Function with Dates in Excel (4 Examples)
Learn how to use the IF function with dates in Excel to check overdue tasks, identify due today, and test if a date falls within a range.
Read article
Author & Spreadsheet Consultant
Sazeda Rahman
104 Articles PublishedPublishing since
Sazeda Rahman Setu holds a BSc and MSc in Mathematics from National University, providing a strong foundation in analytical and logical thinking for spreadsheet work. Since May 2025, she has gained hands-on experience with Excel and Google Sheets, focusing on formulas, functions, troubleshooting, and step-by-step tutorials. She enjoys creating example datasets and clear guides to help beginners solve spreadsheet problems.
Editorial Review
Articles Published by Sazeda Rahman
Articles by Sazeda Rahman are developed under the guidance of ExcelInsider’s core training program and are technically reviewed by Nehad Ulfat, lead spreadsheet consultant, to ensure accuracy and user-centric value.
Excel Functions & Formulas
IF Statement Between Two Numbers in Excel Formula
Learn how to use the IF formula in Excel to check if a value falls between two numbers, return numeric results, or assign categories.
Read article
Excel Functions & Formulas
How to Use VLOOKUP with Date Range in Excel (3 Examples)
Learn how to use VLOOKUP with date ranges in Excel, plus INDEX-MATCH and LOOKUP methods to return values when dates fall between ranges.
Read article
Excel Functions & Formulas
How to Use HLOOKUP with IF Condition in Excel (3 Examples)
Learn how to use HLOOKUP with IF in Excel through examples, including bonus conditions, IFERROR for invalid data, and nested IF rules.
Read article
Excel Pro Tips
How to Compare Two Columns & Return a Value in Excel
Learn how to compare two columns in Excel and return a value using IF, MATCH, VLOOKUP, and conditional formatting for differences.
Read article
Excel Pro Tips
How to Lookup Multiple Values in Excel (4 Suitable Examples)
Learn how to look up multiple values in Excel using FILTER, TEXTJOIN with IF, XLOOKUP, and advanced criteria-based lookup methods.
Read article
Excel Pro Tips
How to Use Real Time Currency Converter in Excel
Learn how to create a real-time currency converter in Excel using Power Query, Exchange Rate API, XLOOKUP, VLOOKUP, and auto-refresh.
Read article
Excel Pro Tips
How to Generate Random Numbers in Excel with No Repeats
Learn how to generate random numbers in Excel without repeats using SORTBY, SEQUENCE, RANDARRAY, INDEX, UNIQUE, and RANDBETWEEN.
Read article
Excel Pro Tips
How to Convert Decimal to Binary in Excel (3 Simple Ways)
Learn how to convert decimal to binary in Excel using DEC2BIN, BASE, and IF functions to handle large values and negative numbers easily.
Read article
Google Sheets Formulas
How to Multiply Column by a Constant in Google Sheets
Learn how to multiply a column by a constant in Google Sheets using basic formulas, ARRAYFORMULA, or a constant stored in another cell.
Read article
Google Sheets Formulas
How to Add Years to Date In Google Sheets (2 Simple Ways)
Learn how to add years to date in Google Sheets using the DATE function or apply the EDATE function to add years by months easily.
Read article
Google Sheets Formulas
How to Round Up to the Nearest 100 in Google Sheets
Learn how to round up to the nearest 100 in Google Sheets using CEILING, ROUNDUP with logic, IF and INT, or ARRAYFORMULA for automation.
Read article