How can I make the 'false' statement remove if blank

Solved
Report
-
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
-
Hello,

I have this simple formula

=IF(J15<>"",J15-H15)

I have that formula alocated to G8 and I want it to work only when I type something inside J15. All its fine, except the fact that I have a 'False' text inside my G8.... can I get a blank cell? Or a 0?



System Configuration: Android / SamsungBrowser 14.2

2 replies

Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
Pupic4fun, Good evening.

Try to use: =IF(J15<>"", J15-H15, "")

Please, tell us if it worked as you desire.

I hope it helps.
Yesssss.... it's great....

Thank you so much!!!!
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
Pupic4fun, Good morning.

Thanks for the feedback.

Glad to help you.

Have a nice day.