| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formula-Sum or 0
I have a worksheet where B1 has a beginning balance and B2 has a current
balance. The formula in B2 is =B1-SUM(B4:B20) I want the current balance to be displayed only if the value in A2 is 0 If the value in A2 is <=0, then I want B2 to display "None" instead of a current balance. Is this possible using a conditional formula? Or is this even possible? Thanks!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CONDITIONAL FORMULA | Excel Discussion (Misc queries) | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Formula, Conditional Formula Needed | Excel Discussion (Misc queries) | |||
| Conditional Formula to indicate Formula in cell | New Users to Excel | |||
| Conditional Sum Formula | Excel Discussion (Misc queries) | |||
Threaded Mode
