Calculation Problem | ww.wp.xz.cn

Resolved aarif007
(@aarif007)

7 years, 2 months ago

Dear TobiasBg,

Thx for your great plugin. After using a formula in a table I got a value such 2.55555555555555. But I just want to show two digits after the dot (.). Is there any solution for that?

Viewing 3 replies - 1 through 3 (of 3 total)

Plugin Author Tobias Bäthge
(@tobiasbg)

7 years, 2 months ago

Hi,

thanks for your post, and sorry for the trouble.

Yes, you will need to add an extra ROUND() or NUMBER_FORMAT() call around your formula. Please see https://tablepress.org/tablepress-features-formulas/ for details.

Regards,
Tobias

Thread Starter aarif007
(@aarif007)

7 years, 2 months ago

How to use this in a calculation like this one, =Ratio: {100/[table-cell id=612 cell=K1 /]*[table-cell id=612 cell=H1 /]}%
Plugin Author Tobias Bäthge
(@tobiasbg)

7 years, 2 months ago
Hi,

like this maybe:
```
=Ratio: {ROUND( 100/[table-cell id=612 cell=K1 /]*[table-cell id=612 cell=H1 /], 2 )}%
```
Regards,
Tobias

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Calculation Problem’ is closed to new replies.

3 replies
2 participants
Last reply from: Tobias Bäthge
Last activity: 7 years, 2 months ago
Status: resolved