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
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?
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:
- How can I make the 'false' statement remove if blank
- Fenix internet on bank statement - Guide
- Remove false from if statement ✓ - Office Software Forum
- How to remove call barring in keypad mobile - Android Forum
- How to undo remove link on instagram bio - Instagram Forum
- Remove wga - Download - Cleaning and optimization
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
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.
Try to use: =IF(J15<>"", J15-H15, "")
Please, tell us if it worked as you desire.
I hope it helps.
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 21, 2021 at 08:45 AM
Jul 21, 2021 at 08:45 AM
Pupic4fun, Good morning.
Thanks for the feedback.
Glad to help you.
Have a nice day.
Thanks for the feedback.
Glad to help you.
Have a nice day.
Jul 20, 2021 at 07:20 PM
Thank you so much!!!!