[Solved] Cell with formula displays nothing

Discuss the spreadsheet application
Post Reply
ApacheChopper
Posts: 3
Joined: Fri May 07, 2021 1:41 am

[Solved] Cell with formula displays nothing

Post by ApacheChopper »

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
User avatar
MrProgrammer
Moderator
Posts: 4895
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Cell Won't Populate

Post by MrProgrammer »

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, MacOS 13.6.3, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
ApacheChopper
Posts: 3
Joined: Fri May 07, 2021 1:41 am

Re: Cell Won't Populate

Post by ApacheChopper »

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 107 times
OpenOffice 4.1.7 on Windows 10
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Cell Won't Populate

Post by RoryOF »

Right click on H7 and choose a cell format with decimal places.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
MrProgrammer
Moderator
Posts: 4895
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Cell Won't Populate

Post by MrProgrammer »

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, MacOS 13.6.3, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
ApacheChopper
Posts: 3
Joined: Fri May 07, 2021 1:41 am

Re: Cell with formula displays nothing

Post by ApacheChopper »

Thank you so much! :D
OpenOffice 4.1.7 on Windows 10
Post Reply