CODEWITHSUNDEEP
excel
VM4
VM4

Reputation: 63

Take cell value from a cell containing a function/formula

enter image description here

From the picture, I want to find the distance traveled. My formula @ cell O83 looks something like : =$M83- $M82. But O83 returns Zero. Note: column M82 contains a formula. Question: how do I extract and use just the value from a function?

Upvotes: 0

Views: 48

Answers (1)

Imran Malek
Imran Malek

Reputation: 1719

Your problem is the formatting that you might have applied on the cell O82

See the example below enter image description here

If you remove the formats on the problematic cells you'll see the correct results. enter image description here

To do so select all the range O82:O100 and click on clear formats from home tab.

enter image description here

Upvotes: 1

Related Questions