![]() |
How do I write "Either / Or" Display Formulas?
I am attempting to duplicate a checkbook register. I need to know how to
display either the withdrawal or the deposit under the running balance. How do I write a formula for an either / or display? |
How do I write "Either / Or" Display Formulas?
If you enter withdrawals as negative, deposits as positive, you don't need
either/or, just ass them in. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Cleso" wrote in message ... I am attempting to duplicate a checkbook register. I need to know how to display either the withdrawal or the deposit under the running balance. How do I write a formula for an either / or display? |
How do I write "Either / Or" Display Formulas?
i use seperate columns for deposits and withdrawals with the balance at the
bottom -- paul remove nospam for email addy! "Cleso" wrote: I am attempting to duplicate a checkbook register. I need to know how to display either the withdrawal or the deposit under the running balance. How do I write a formula for an either / or display? |
How do I write "Either / Or" Display Formulas?
Thanks! Got it.
"paul" wrote: i use seperate columns for deposits and withdrawals with the balance at the bottom -- paul remove nospam for email addy! "Cleso" wrote: I am attempting to duplicate a checkbook register. I need to know how to display either the withdrawal or the deposit under the running balance. How do I write a formula for an either / or display? |
How do I write "Either / Or" Display Formulas?
Thanks, Bob. Your post made me think of how I was enering the data and how I
wanted to see the display. I simplified it and all is good. "Bob Phillips" wrote: If you enter withdrawals as negative, deposits as positive, you don't need either/or, just ass them in. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Cleso" wrote in message ... I am attempting to duplicate a checkbook register. I need to know how to display either the withdrawal or the deposit under the running balance. How do I write a formula for an either / or display? |
All times are GMT +1. The time now is 04:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com