How NOT to show False in the following example.
Peter
-
Mar 11, 2023 at 06:34 PM
Herminaandrews Posts 4 Registration date Tuesday March 7, 2023 Status Member Last seen March 12, 2023 - Mar 12, 2023 at 10:13 AM
Herminaandrews Posts 4 Registration date Tuesday March 7, 2023 Status Member Last seen March 12, 2023 - Mar 12, 2023 at 10:13 AM
Related:
- How NOT to show False in the following example.
- How to remove false in excel ✓ - Office Software Forum
- Removing "FALSE" from an IF statement with a VLOOKUP ✓ - Excel Forum
- Need help to remove FALSE from cell ✓ - Office Software Forum
- Removing False Value ✓ - Excel Forum
- Removing false in excel ✓ - Excel Forum
1 reply
Herminaandrews
Posts
4
Registration date
Tuesday March 7, 2023
Status
Member
Last seen
March 12, 2023
Mar 12, 2023 at 10:13 AM
Mar 12, 2023 at 10:13 AM
Hello,
To return a blank cell if there are any blank cells in your formula, you can add an additional IF statement to check if any of the cells you're referencing are blank. Here's an example of what your formula could look like with this added check:
=IF(OR(C27="",D27="",D30=""),"",IF(C27="BUY",((D30-D27)*10000),IF(C27="SELL",((D27-D30)*10000))))
The OR statement checks if any of the cells C27, D27, or D30 are blank. If any of them are blank, the formula returns a blank cell. If none of them are blank, the original IF statement is executed to return the appropriate value based on the value in cell C27.
I hope this helps!