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

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

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

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