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.
That is not possible. A function always returns something.
Both the C and the C++ languages have functions that do not return values. Excel itself is written in C++. Although BASIC is a separate language, VBA (and VB6) itself is actually just a library of wrapper functions (formed to simulate the BASIC dialect) around Win32 API functions that are written in the C and assembly languages. If one of Microsoft's developers decides to put their brain to actual use and stop limiting their noggings to what other failed innovators believe is "possible", I'm just betting they can use that fancy-dancy C++ or C language to create a higher-level of abstraction "function" in Excel that doesn't return a value when the condition evaluates to False, or rather, Excel takes no action to assign any value to the associated cell when the condition of a contained function evaluates to False. The foreign developers who have swarmed and taken over the Redmond campus since I was last there more than a decade ago may not have the actual experience to accomplish this task, and Microsoft likely won't ever put forward the budget to achieve it. But, yes, it is possible and it can be done.
They'd have to change the way VBA works, so it is indeed very unlikely that it will happen.