[Solved] Not show formula error

Discuss the spreadsheet application
Post Reply
metalman
Posts: 2
Joined: Thu Jul 29, 2021 8:55 pm

[Solved] Not show formula error

Post by metalman »

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.
Attachments
post 2.JPG
post 1.JPG
Last edited by MrProgrammer on Fri Jul 30, 2021 12:07 am, edited 2 times in total.
Reason: Tagged ✓ [Solved]
windows 10 /OpenOffice 4.1.6
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Not show formula

Post by FJCC »

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.
metalman
Posts: 2
Joined: Thu Jul 29, 2021 8:55 pm

Re: Not show formula

Post by metalman »

Thanks, 2 hours searching and post and reply back in 5 minutes and it works, thanks again
windows 10 /OpenOffice 4.1.6
Post Reply