Prev: Is there a simple way to generate patterns of numbers in XL ?
Next: Adding current dates to adjacent cells automatically.
From: Kevryl on 13 Apr 2010 05:29
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.

"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
First  |  Prev  | 
Pages: 1 2
Prev: Is there a simple way to generate patterns of numbers in XL ?
Next: Adding current dates to adjacent cells automatically.