Page 1 of 1

[Solved] Cell with formula displays nothing

PostPosted: Fri May 07, 2021 1:58 am
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.

Re: Cell Won't Populate

PostPosted: Fri May 07, 2021 2:02 am
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

Re: Cell Won't Populate

PostPosted: Fri May 07, 2021 10:28 pm
by ApacheChopper
Please see the attached sheet.
Cell H7 is the one that won't populate.
Thank you & have a nice weekend.

Re: Cell Won't Populate

PostPosted: Fri May 07, 2021 10:50 pm
by RoryOF
Right click on H7 and choose a cell format with decimal places.

Re: Cell Won't Populate

PostPosted: Sat May 08, 2021 12:38 am
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.

Re: Cell with formula displays nothing

PostPosted: Sun May 09, 2021 5:18 am
by ApacheChopper
Thank you so much! :D