How can I make the 'false' statement remove if blank [Solved]

Report
-
Posts
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 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
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
144
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
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
144
Pupic4fun, Good morning.

Thanks for the feedback.

Glad to help you.

Have a nice day.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!