exceltoxl.com

Hi there,

  Share on Facebook

Today, we will know about

• What is Volatile and its definition? 
• How it is related to Excel? (If at all related)
• How many Volatile functions are available in Excel? 

Volatile Meaning and its Definition: Volatile is 

"easily evaporated" in terms of Chemistry or

"content will be erased if the power switch-offs the computer" in terms of Computer memory or

"readily vaporizable at relatively low temperature and so on...

...

These definitions are depends on the different categories.

However, in terms of Excel,

Volatile is nothing but changing the value of the cell if user refresh the worksheet (keyboard shortcut is Shift + F9) or workbook (keyboard shortcut is F9)

in other words

the cell contains volatile function will recalculate the value every time when the worksheet or workbook gets refreshed.

There are few functions which acts like a VOLATILE in Excel are called VOLATILE FUNCTIONS.

We have a list of Excel volatile functions here:

The value will change for every refresh

1. RAND()
   
2. NOW()
3. TODAY()

1. OFFSET()
   
2. INFO()
3. INDEX()
4. INDIRECT()
5. CELL()
6. AREAS()
7. COLUMNS()
8. ROWS()

DID YOU FIND THIS USEFUL?

I am sure every one will use volatile functions on day-to-day basis. Did you find any thing challenging, Did you resolve any difficult tasks while working on volatile functions, want to share your experience with us on this topic then please do post your comments in the comment section below. 

Appreciate your valuable time.

Thanks,