![]() |
|
#1
|
||||
|
||||
![]() Are you trying to increment B1 every time A1>A2, or only to add 1 to whatever is there while A1>A2? If it's the former, you can't do it with a formula - you'd need a macro.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#2
|
|||
|
|||
![]()
i just want to add 1 to whatever is in B1. like if A1>A2 then 1 will show up in B1, and if i did A3>A4 in another cell and wanted to add 1 to B1 again, it wont add 1 to it, it will jus tshow up as 1, over and over.
|
![]() |
|