Conditional Formula-Sum or 0

E

Elara

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!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multi-demensional frequency distribution 4
formula required (2nd time) 6
INDEX and MAPPING 4
Balance sheet functions? 2
Excel formula, sum the value cell and if empty cell left blank 0
Excel 2007 SP2 Addition of Negative Numbers Error 7
Conditional Formatting Formula 6
how do i add a formula to a cell that will add or subrtact from d. 2

Top