Prev: function help for counting text as a value....
Next: IF formula
From: chosita on 14 Dec 2009 20:46
A B C D
E
AMOUNT INCOME DUE DATE DATE PAID BALANCE

0
If row 1, column D is blank, I want balance to post in Row 2 Column E,
leaving R1C
blank. is this possible ? Would it require a formula or function and how
would you writ it , plus where would you past it?
From: Fred Smith on 14 Dec 2009 22:12
You need to be clearer in your request. The following will help you get
faster, more accurate answers:
-- Use cell addresses, as in D1, E2, etc. It's not clear what you mean by
"R1C"
-- Tell us how you would calculate Balance manually. Do you take Amount
(column A) into account? What about income (column B)? Do you start with the
previous balance?
-- If you want to see a result in E2, you *always* put the formula in that
cell. Formulas can affect only the cell they are in.

As a guess, you want in E2 something like:
=if(d1="",<your balance calculation>,<what you want when D1 is not blank)

Regards,
Fred.

"chosita" <chosita(a)discussions.microsoft.com> wrote in message
news:AA56C485-14DA-42D4-9F18-BFE4AB929027(a)microsoft.com...
> A B C D
> E
> AMOUNT INCOME DUE DATE DATE PAID BALANCE
>
> 0
> If row 1, column D is blank, I want balance to post in Row 2 Column E,
> leaving R1C
> blank. is this possible ? Would it require a formula or function and how
> would you writ it , plus where would you past it?

 | 
Pages: 1
Prev: function help for counting text as a value....
Next: IF formula