Forum Discussion

VShostak's avatar
VShostak
Copper Contributor
Oct 30, 2023

The diagrama does not want to correctly display the result of the function

Hello   The diagrama does not want to correctly display the result of the function " =IF(U:U="";"";U:U-$AI$3) ", diagrama "breaks" when it hits an empty cell created by the function. Is it possible...
Formulas and Functions
JKPieterse's avatar
JKPieterse
Silver Contributor
Oct 30, 2023
What if you change the formula to:
=IF(U:U="";NA();U:U-$AI$3)
  • VShostak's avatar
    VShostak
    Copper Contributor
    Oct 30, 2023
    It worked, thanks a lot!

Resources