i am trying to say =if a2 is greater than 2000 add 250

  • Thread starter Thread starter slater
  • Start date Start date
S

slater

i am a new excell user 2007 how do i get the formula to say if A@ is greater
than
2000 add 250
 
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.
 
One more suggestion: With inflation you may want to "future proof" it:
Suggest use absolute ranges for criterion and add amount. Like this:

Name (say) C1 as something like "ChangeLevel"
Name (say) D6 as something like "AddAmount"
(Naming ranges simplifies the replicating of formulae across or down the page)

Write your formula as "=if(A2>ChangeLevel,A2+AddAmount),A2)"

This allows you to update every row from just 1 or 2 cells. Remember tho
that it will do just that - EVERY row in which that formula appears!

If you are replicating the formula along the row to apply to several columns
(eg price break levels), using the $ sign (like A$2) will maintain the
connection to column A

Tip: Incorporating "=Max(xx,xx1)" and "=Min(xx,xx1)" (where xx and xx1 are
cells or ranges) can sometimes add a lot of power and functionality to "=IF"
formulae too.
 
Back
Top