Forum Discussion
IFTRUE() formula that does nothing if False
This was meant to be a suggestion for a new feature in a future version of Excel. Since Microsoft changes links for suggestions like I change my own underwear, this is where the latest link sent me to make a feature suggestion. As far as it being possible... that is actually the whole point of suggesting the feature - to make it possible. It is not currently a feature but it can become a feature. And yes, Microsoft's programmers should have the ability to include such a formula within future versions of Excel without user's having to resort to VBA. If they can't, then Microsoft needs to hire more imaginative and more capable developers.
As far as I know, this is not possible. A worksheet function ALWAYS returns something to the cell it is in, even if only the empty string "".
The custom VBA function
Function IFTRUE(condition As Boolean, value_if_true As Variant) As Variant
If condition Then
IFTRUE = value_if_true
End If
End Functionwill return 0 in a cell if the condition is FALSE.
This was meant to be a suggestion for a new feature in a future version of Excel. Since Microsoft changes links for suggestions like I change my own underwear, this is where the latest link sent me to make a feature suggestion. As far as it being possible... that is actually the whole point of suggesting the feature - to make it possible. It is not currently a feature but it can become a feature. And yes, Microsoft's programmers should have the ability to include such a formula within future versions of Excel without user's having to resort to VBA. If they can't, then Microsoft needs to hire more imaginative and more capable developers.