Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to write formulas in excel for money to days | New Users to Excel | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
OLAP write back via formulas (functions), not read only pivot tab | Excel Worksheet Functions | |||
how do i display formulas in only certain cells? | Excel Worksheet Functions | |||
Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions |