How do I write "Either / Or" Display Formulas? in Excel General Questions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
Cleso 1/22/2006 3:20 PM PST
  Question
  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?
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Bob Phillips 1/22/2006 3:32 PM PST
  Answer
  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" <Cleso@discussions.microsoft.com> wrote in message
news:3CE47EDE-5CA0-4F40-A196-FDEFA2E3E3BA@microsoft.com...
> 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?


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Cleso 1/22/2006 4:19 PM PST
   
  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" <Cleso@discussions.microsoft.com> wrote in message
> news:3CE47EDE-5CA0-4F40-A196-FDEFA2E3E3BA@microsoft.com...
> > 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?
>
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
paul 1/22/2006 3:48 PM PST
  Answer
  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?
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Cleso 1/22/2006 4:19 PM PST
   
  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?
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies