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
Either or Formula 4
If Function neglecting 0 as a number 1
Excel 2007 SP2 Addition of Negative Numbers Error 7
Skip Reference Sequences during copy 3
Excel 2003 with Reference error cause me a headache 0
Conditional Formatting Formula 6
Copying cell formulas 1

Top