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

Solved/Closed
Pupic4fun - Updated on Jul 20, 2021 at 06:51 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 21, 2021 at 08:45 AM
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 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jul 20, 2021 at 07:03 PM
Pupic4fun, Good evening.

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

Please, tell us if it worked as you desire.

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

Thank you so much!!!!
0
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jul 21, 2021 at 08:45 AM
Pupic4fun, Good morning.

Thanks for the feedback.

Glad to help you.

Have a nice day.
0