[Solved] Not show formula error
[Solved] Not show formula error
I would like for the cell (A22)to either show nothing or zero, only when I select from the drop down and the value changes(C6) from zero does the formula change to zero,thanks.
Last edited by MrProgrammer on Fri Jul 30, 2021 12:07 am, edited 2 times in total.
Reason: Tagged ✓ [Solved]
Reason: Tagged ✓ [Solved]
windows 10 /OpenOffice 4.1.6
Re: Not show formula
Code: Select all
=IF(C6>0;D21/C6*I5;"")
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Not show formula
Thanks, 2 hours searching and post and reply back in 5 minutes and it works, thanks again
windows 10 /OpenOffice 4.1.6