Thread: [Solved] Hi can somebody help me out?
View Single Post
 
Old 04-09-2013, 03:07 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit 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
From what you describe, your formula (in a cell other than B1) should be:
=B1+(A1>A2)
or, if you're doing this directly in B1 and the default value is, say, 10:
=10+(A1>A2)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote