i am trying to say =if a2 is greater than 2000 add 250
in [General]
|
Prev: Is there a simple way to generate patterns of numbers in XL ?
Next: Adding current dates to adjacent cells automatically.
From: slater on 30 Mar 2010 21:35 i am a new excell user 2007 how do i get the formula to say if A@ is greater than 2000 add 250
From: JLatham on 30 Mar 2010 21:46 Hopefully you don't want to do this in A2 itself because trying that will give you a 'circular reference' error. But in another cell you can put: =IF(A2>2000,A2+250,"not greater than 2000") The "not greater than 2000" portion could be another formula, or reference to a cell, such as =IF(A2>2000,A2+250,A2) would either show A2 + 250 or just the value in A2 =IF(A2>2000,A2+250,A3) would show A2+250 result if A2>2000 otherwise would show value in A3 or =IF(A2>2000,A2+250,"") would show A2+250 result if A2>2000 otherwise would just be blank. Hope this helps. "slater" wrote: > i am a new excell user 2007 how do i get the formula to say if A@ is greater > than > 2000 add 250
From: Russell Dawson on 30 Mar 2010 21:50 Hi Slater, Your description almost says it the way the formula goes although you have not said what you want the 250 to be added to. I've assumed that you want it to be added to the original figure in A2 so: =IF(A2>2000,A2+250,A2) That's saying If A2 is greater than 2000 then display A2 figure plus 250 otherwise just display A2 figure. -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "slater" wrote: > i am a new excell user 2007 how do i get the formula to say if A@ is greater > than > 2000 add 250
From: Bernd P on 30 Mar 2010 21:49 =IF(A1>2000,A1+250,A1)
From: "David Biddulph" groups [at] on 31 Mar 2010 03:11
.... or =A2+250*(A2>2000) -- David Biddulph "Russell Dawson" <russell.dawson(a)discussions.microsoft.com> wrote in message news:FE1E1EC1-22A6-498B-8A45-92F4DEC1A717(a)microsoft.com... > Hi Slater, > > Your description almost says it the way the formula goes although you have > not said what you want the 250 to be added to. I've assumed that you want > it > to be added to the original figure in A2 so: > > =IF(A2>2000,A2+250,A2) > > That's saying If A2 is greater than 2000 then display A2 figure plus 250 > otherwise just display A2 figure. > > -- > Russell Dawson > Excel Student > > Please hit "Yes" if this post was helpful. > > > "slater" wrote: > >> i am a new excell user 2007 how do i get the formula to say if A@ is >> greater >> than >> 2000 add 250 |