Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-09-2013, 02:55 AM
macropod's Avatar
macropod macropod is offline Hi can somebody help me out? Windows 7 64bit Hi can somebody help me out? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default


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]
Reply With Quote
  #2  
Old 04-09-2013, 12:10 PM
Aybara Aybara is offline Hi can somebody help me out? Mac OS X Hi can somebody help me out? Office for Mac 2011
Novice
Hi can somebody help me out?
 
Join Date: Apr 2013
Posts: 2
Aybara is on a distinguished road
Default

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.
Reply With Quote
Reply



Other Forums: Access Forums

All times are GMT -7. The time now is 09:24 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft