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.
Yesssss.... it's great....

Thank you so much!!!!
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.