Want to give a value to each cell

Closed

rasel - Feb 13, 2010 at 10:30 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 14, 2010 at 08:07 AM

Hello,
normally the value of each cell in excel is 0. but i want that the value of each cell will be 20.like whenever i ll add add 5 with any cell it will return 25.how can i do that?

mostafiz

Want to give a value to each cell
Excel send value to another cell - Guide
If cell contains date then return value ✓ - Excel Forum
Excel "IF" function w/ date in test cell ✓ - Excel Forum
An example of a cell is a blank cell ✓ - Programming Forum
Which key is used to make multiple line in a single cell - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 14, 2010 at 08:07 AM

you have to define your own function to do that sort of sum, so instead of using A1+B1 or Sum(A1:B1), you would be calling that function to do the sum

Similar discussions

help me to add particular cells

Excel - IF function with multiple words

If cell = date return yes or no.

If a cell contains any text then add a value

Counting cells containing only numbers

Similar discussions

Subscribe To Our Newsletter!