[Solved] Cell with formula displays nothing

Discuss the spreadsheet application

[Solved] Cell with formula displays nothing

Postby ApacheChopper » Fri May 07, 2021 1:58 am

The following formula appears in the formula bar, which is wonderful: =B7*1.25
But nothing appears in the target cell, not the calculation result, nor the formula.
I'd be very grateful if someone could solve this conundrum.
Last edited by robleyd on Sun May 09, 2021 6:21 am, edited 1 time in total.
Reason: Tagged [Solved]; add green tick
OpenOffice 4.1.7 on Windows 10
ApacheChopper
 
Posts: 3
Joined: Fri May 07, 2021 1:41 am

Re: Cell Won't Populate

Postby MrProgrammer » Fri May 07, 2021 2:02 am

Hi, and welcome to the forum.

ApacheChopper wrote:The following formula appears in the formula bar, which is wonderful: =B7*1.25
But nothing appears in the target cell, not the calculation result, nor the formula.
Attach a document demonstrating the difficulty (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself).

[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 4109
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Cell Won't Populate

Postby ApacheChopper » Fri May 07, 2021 10:28 pm

Please see the attached sheet.
Cell H7 is the one that won't populate.
Thank you & have a nice weekend.
Attachments
BSD_Forum.ods
Cell H7
(15.41 KiB) Downloaded 48 times
OpenOffice 4.1.7 on Windows 10
ApacheChopper
 
Posts: 3
Joined: Fri May 07, 2021 1:41 am

Re: Cell Won't Populate

Postby RoryOF » Fri May 07, 2021 10:50 pm

Right click on H7 and choose a cell format with decimal places.
Apache OpenOffice 4.1.10 on Xubuntu 20.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 32957
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Cell Won't Populate

Postby MrProgrammer » Sat May 08, 2021 12:38 am

ApacheChopper wrote:Cell H7 is the one that won't populate.
The display in H7 was exactly what you had requested. The formula value was 0.3125. The numeric cell format (Format → Cells → Numbers → Format code) was # which says to display only the (rounded) integer part but don't display a zero value. Read about format codes in OpenOffice Help → Index → format codes;numbers. A good format code to specify in this situation (nothing shown) is Category → All → Format → General.

Your formula in G7 is =SUM(D7/A7). The SUM function is unnecessary. Calc divides D7 by A7 to get a quotient. No addition is needed in the formula so you don't need to use SUM. A shorter formula is =D7/A7. This topic is in section 9 of the tutorial in my first post.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the subject field. Select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 4109
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Cell with formula displays nothing

Postby ApacheChopper » Sun May 09, 2021 5:18 am

Thank you so much! :D
OpenOffice 4.1.7 on Windows 10
ApacheChopper
 
Posts: 3
Joined: Fri May 07, 2021 1:41 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 26 guests