ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I write "Either / Or" Display Formulas? (https://www.excelbanter.com/excel-discussion-misc-queries/66711-how-do-i-write-either-display-formulas.html)

Cleso

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?

Bob Phillips

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?




paul

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?


Cleso

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?


Cleso

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