| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
ADD 1 to a cell if condition is met.
I want 1 point to be added to A1 if A2 equals 10,000. A2 is the sum of other
cells. I need A1 to be save. Right now, it goes back to previous score when A2 is back to zero. Help Obiwan.. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
ADD 1 to a cell if condition is met.
Look he
http://www.mcgimpsey.com/excel/accumulator.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Ron" wrote in message ... I want 1 point to be added to A1 if A2 equals 10,000. A2 is the sum of other cells. I need A1 to be save. Right now, it goes back to previous score when A2 is back to zero. Help Obiwan.. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
ADD 1 to a cell if condition is met.
Thank you! Works great!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set more then 3 Condition for a cell? | Excel Discussion (Misc queries) | |||
| How can I make a cell = another cell based on a condition? | Excel Worksheet Functions | |||
| Moving to cell based on condition of another cell | Excel Discussion (Misc queries) | |||
| Hide cell values based on a condition in another cell | Excel Worksheet Functions | |||
| I want to fill the cell color based upon the other cell condition | Excel Discussion (Misc queries) | |||
Linear Mode
