[AccessD] OT: Excel VBA - Formula versus Value

Writing Excel VBAs for years I’ve always used the property Value, and suddenly it strikes me:  What’s the difference between Formula and Value?

Below examples lead to same result:

Range(“A1”).Value = “Test” 

Range(“A1”).Formula = “Test” 

Range(“A1”).Value = “=B1+B2” 

Range(“A1”).Formula = “=B1+B2”

Is Value versus Formula only a matter of code readability?

 

Asger