IF ISBLANK TRUE do this, IF ISBLANK False do that, IF no input do not show

[SunnyMoon]

Hi Everyone,

I am trying to make the Balance column not show if the IN or OUT column has no value
I am not sure if this is possible or not

This is where i'm currently at right now.
If B17 is blank, calculate D16-C17
If B17 is not blank, calculate D16+B17

Any suggestion would really be appreciated.
Thanks

 

[etaf]

you formula is calculating if B17 is blank
your text says
Balance column not show if the IN or OUT column has no value

=IF( OR( B10="",C10="") , "", Formula )

that will be blank if Either B or C is blank

not sure thats what you meant

maybe some more examples

B10 = Blank , C10 is NOT blank = what do you require
B10 = is NOT Blank , C10 is blank = what do you require
Both B10 & C10 are blank = = what do you require

 

[ExceLoki]

Book1
	A	B	C	D
1	date	in	out	balance
2	11/20/2022			$ 149,433.00
3			$ 159.00	$ 149,274.00
4			$ 50.00	$ 149,224.00
5			$ 95,000.00	$ 54,224.00
6		$ 175.00		$ 54,399.00
7			$ 52,729.00	$ 1,670.00
8	11/21/2022		$ 60.00	$ 1,610.00
9		$ 300.00		$ 1,910.00
10
Sheet1

Cell Formulas
Range	Formula
D3:D10	D3	=IFS(AND(B3="",C3=""),"",B3="",D2-C3,B3<>"",D2+B3)

 

[SunnyMoon]

It worked like magic! Thank you so much!

 

[ExceLoki]

no worries, happy to help. thanks for the feedback