HELP how to avoid a value repeating when draging an IF formula down a column?

Question

Using Open Office having difficulty in formating an 'IF'. formula.
require to provide a simple bank style statement - ie in D3
"IF C3andD3 <1 'ISBLANK' otherwise SUM= D2-C3+D3
D2 being opening balance, C3 a debit or D3 credit - and so on
down the sheet BrianUK

Answer 1

Your question is eroneous, you will generate a circular ref. if you write your formula in D3 and test if D3 is < 1. Normally you would use three columns, 1 for debit, 1 for credit and 1 for balance ( col E). Doing this you do not actually need an IF formula, all you need is =E2 - C3 + D3

If you want to use 2 cols, then you will also need to use 2 rows; ie. C3 a debit, D3 a credit and D4 a balance. The next sequence will be C5, D5 and D6. The formula will still work, but copy down in pairs of rows.

The AND formula goes AND(C3<1,D3<1) the ISBLANK(cellref) needs a cell reference. Remember ISBLANK is boolean and needs to be in the first part of the argument.

Answer 2

Type $C$3 and this value will not change when you drag the formula down a column.

Answer 3

You write all those details, but yet you don't explain the problem. What value is repeating, and how is it repeating?

What does the formula look like in the rows that the repetition occurs? What do the values look like in those very rows?

Are you talking about absolute versus relative?
___________________________

Answer 4

Actually it is happens some times, the main thing to be internet in your pc and second one the software installed in your pc may be older version so it simply need to required updation nothing else........


http://www.commediait.com