Use Smart Fill to help automate data entry in Google Sheets
Before we talked about how Google sheets is getting smarter. And finally in the last update from Google, now we …
Read moreUse Smart Fill to help automate data entry in Google Sheets
How to Use ISODD in Google Sheets in 2020?
ISODD in Google Sheets checks whether the provided value is odd. Sample Usage ISODD(4) ISODD(A2) Syntax ISODD(value) value – The …
How to Use FALSE in Google Sheets in 2020?
FALSE Returns the logical value `FALSE`. Sample Usage FALSE() Syntax FALSE() Notes In most cases, Google Sheets will automatically convert …
How to Use FALSE in Google Sheets in 2020?
FALSE Returns the logical value `FALSE`. Sample Usage FALSE() Syntax FALSE() Notes In most cases, Google Sheets will automatically convert …
Google Sheets Invoice Templates; How to Create one
Are you struggling with finding the right template for your monthly invoicing? Sometimes, that can be hard and struggling, especially …
How to Use Z.TEST in Google Sheets in 2020?
Z.TEST Returns the one-tailed P-value of a Z-test with the standard distribution. Sample Usage =Z.TEST(A2:A100,B2) =Z.TEST({1,2,3,4,5,6},5.5,1.2) Syntax Z.TEST(data, value, [standard_deviation]) …
How to Use YIELDDISC in Google Sheets in 2020?
YIELDDISC Calculates the annual yield of a discount (non-interest-bearing) security, based on price. Sample Usage YIELDDISC(DATE(2010,01,02),DATE(2010,12,31),98.45,100) YIELDDISC(A2,B2,C2,D2,2) Syntax YIELDDISC(settlement, maturity, …
How to Use XNPV in Google Sheets in 2020?
XNPV Calculates the net present value of an investment based on a specified series of potentially irregularly spaced cash flows …
How to Use XIRR in Google Sheets in 2020?
XIRR Calculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced cash …
Essential Add-Ons For Google Sheets
Are you new to Google spreadsheets and you can’t find the functions you’re looking for? Add-ons are third-party plugins that …