Value should not cange in cell A15

Closed

chandras - Sep 24, 2010 at 06:04 AM
rayh - Sep 27, 2010 at 03:29 PM

Hello,

this is chandu. if w e sum A1: A10 in A15 and if we delete the values in that cells A1: A10 the value should not cange in cell A15. for that which command i have to use pls help me with ur suggestions.

Value should not cange in cell A15
How to delete cell in word - Guide
Excel multiple lines in one cell - Guide
Insert the current date and time in cell a1 ✓ - Excel Forum
Based on the values in cells b77:b81, which function can automatically return the value in cell c77? ✓ - Excel Forum
Based on the values in cells b77 b81 what function can automatically return the value in cell c77 ✓ - Excel Forum

2 responses

Answer 1 / 2

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 26, 2010 at 08:04 PM

there must be many ways to do it. I suggest data validation.

Answer 2 / 2

rayh
Sep 27, 2010 at 03:29 PM

Because cell A15 contains a formula it value will change whenever the values it is summing changes.
You can copy, then paste special, values to retain the value.

Similar discussions

help me to add particular cells

Clear cell contents based on value of another cell range using VBA

Looking For a Value in a Cell

Fill adjacent cell with number from text answer

If a cell contains any text then add a value

Similar discussions

Subscribe To Our Newsletter!