Previous Topic Next Topic

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
Related:

2 responses

Answer 1 / 2
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
Pupic4fun
Jul 20, 2021 at 07:20 PM
Yesssss.... it's great....

Thank you so much!!!!
0
Answer 2 / 2
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

Similar discussions

Removing " false" value in "IF"
JIN -
share -

10 responses
Can't remove threat with Windows Defender
Babarali4 -
ravida_1351 -

2 responses
How to undo "remove link" in bio?
mary22 -
Gourav -

13 responses