i am trying to say =if a2 is greater than 2000 add 250
.... or =A2+250*(A22000)
--
David Biddulph
"Russell Dawson" wrote in message
...
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(A22000,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
|