Forum Discussion

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 to somehow write an empty cell so that the chart displays correctly.

Thanks

Formulas and Functions

2 Replies

JKPieterse
Silver Contributor
Oct 30, 2023
What if you change the formula to:
=IF(U:U="";NA();U:U-$AI$3)
- VShostak
  Copper Contributor
  Oct 30, 2023
  It worked, thanks a lot!