Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |