| 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!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formula-Sum or 0
in B2 put: =IF(A20,B1-SUM(B4:B20),"None")
"Elara" wrote: 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!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formula-Sum or 0
Perfect! Just what I needed! You are a life saver... Thank You!
"sb1920alk" wrote: in B2 put: =IF(A20,B1-SUM(B4:B20),"None") "Elara" wrote: 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!!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formula-Sum or 0
No problem...glad I could help.
"Ana24" wrote: Perfect! Just what I needed! You are a life saver... Thank You! "sb1920alk" wrote: in B2 put: =IF(A20,B1-SUM(B4:B20),"None") "Elara" wrote: 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!!! |
| Reply |
| 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) | |||
Linear Mode
