INDIRECT Function

INDIRECT is used to create reference from text. More so, it can be use to generate random values. it returns reference to a range. Syntax: INDIRECT(ref_text[a1]) ref_text: a cell reference or text string that create the range reference. a1: this is said to be TRUE if the reference is using A1 reference style and FALSE[…]

Shares 0

RAND and RANDBETWEEN functions

RAND() and RANDBETWEEN() functions RAND() is used to generate random decimal number between 0 and 1 with exclusion of 0 and 1. while RANDBETWEEN(bottom_number, top_number) very useful in generate lot of number between specified bound. Hope this post is helpful? For more Insight on Microsoft Excel, kindly buy any of my books “Productivity Boosting Aspects of Microsoft[…]

Shares 0