I have a small problem that my 74 year old brain can't figure out and I have been unable to get any help on the internet or Lotus 123 for Dummies. My problem is that I am trying to figure out a formula for a Simple Lotus 123 checkregister program that I am trying to put together.
My spreadsheet is as follows:
Column D (Debit) ~ Column F (Credit) ~ Column G (Ballance) ~ Column H (Date Cleared Bank) ~ Column I (amount from Column D when the Bank did not clear, otherwise empty.
What I want is for the debit amount (Column D to be copied in Column I if it has not been Cleared by the bank (Column H empty). Column D, F, G, I is formatted for money and Column if formatted for a date.
What I have used is "@IF(H=" "..D+<1,D)" and many many many versions of this formula.
What ever you can help me out with would be greatly appreciated.
cbertsch
My spreadsheet is as follows:
Column D (Debit) ~ Column F (Credit) ~ Column G (Ballance) ~ Column H (Date Cleared Bank) ~ Column I (amount from Column D when the Bank did not clear, otherwise empty.
What I want is for the debit amount (Column D to be copied in Column I if it has not been Cleared by the bank (Column H empty). Column D, F, G, I is formatted for money and Column if formatted for a date.
What I have used is "@IF(H=" "..D+<1,D)" and many many many versions of this formula.
What ever you can help me out with would be greatly appreciated.
cbertsch