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
An example of a cell is a blank cell ✓ - Programming Forum
Conditional formatting if cell contains text - Excel Forum
If cell A1 has text then cell B2 has today's Date ✓ - Excel Forum

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

If a cell contains any text then add a value

help me to add particular cells

If cell = date return yes or no.

Excel: If Date =, then enter a value

Excel "IF" function w/ date in test cell

Similar discussions

Subscribe To Our Newsletter!