View Single Post
 
Old 12-17-2015, 04:19 AM
SumitBansal SumitBansal is offline Windows 10 Office 2013
Novice
 
Join Date: Dec 2015
Location: India
Posts: 6
SumitBansal is on a distinguished road
Default

Since your value in B6 is dependent on B4, it will show 0 as soon as you delete it. You can copy and paste special as values. But that needs to be done every time you change the values.

Another way is to use a VBA code.
Reply With Quote