Automatically add required decimal figure to make destination cell figure in nearest highe

**KRIXXXX** · 07-02-2022, 01:32 PM

Automatically add required decimal figure to make destination cell figure in nearest higher value

Kindly see the attached sheet, I have written comment in it, I think you can understand what kind of result I expect.

**Richard Buttrey** · 07-02-2022, 01:55 PM

Sorry,

I don't understand what you're trying to do. Please clarify with other examples. In addition are you wanting the underlying numbers to be affected or is it just the presentation?

For instance D17 shows zero dec places when set to 2 dec. places but .995 otherwise.

**KRIXXXX** · 07-02-2022, 02:18 PM

In cell D13 figure should be automatically generated to make the figure of Cell D17 round figure

**protonLeah** · 07-02-2022, 02:37 PM

Please Login or Register  to view this content.

**Richard Buttrey** · 07-02-2022, 02:37 PM

Maybe

D13: =D15+D16-D14-D17
D14: =D6+D12
D17: =ROUNDUP(D15+D16-D14,0)

**KRIXXXX** · 07-03-2022, 03:20 AM

Thanks works Great

**KRIXXXX** · 07-03-2022, 03:21 AM

Thanks worked for me

**KRIXXXX** · 07-04-2022, 03:10 AM

Originally Posted by protonLeah

Please Login or Register  to view this content.

But there's a concern here, if amount in Cell D17 is negetive then for example -248818.35 then results should be -248819.00
And if amount in Cell D17 is positive then for example 248818.35 then results should be 248818.00

**Richard Buttrey** · 07-04-2022, 04:35 AM

Maybe in D17 - see #5

=IF(D15+D16-D14<0,ROUNDUP(D15+D16-D14,0),ROUNDDOWN(D15+D16-D14,0))

**KRIXXXX** · 07-05-2022, 12:40 PM

I feel It would be good if you can give formula for D13 cell only like wise #4

Automatically add required decimal figure to make destination cell figure in nearest highe

LinkBack

Thread Tools

Rate This Thread

Display

Automatically add required decimal figure to make destination cell figure in nearest highe

Re: Automatically add required decimal figure to make destination cell figure in nearest h

Re: Automatically add required decimal figure to make destination cell figure in nearest h

Re: Automatically add required decimal figure to make destination cell figure in nearest h

Re: Automatically add required decimal figure to make destination cell figure in nearest h

Re: Automatically add required decimal figure to make destination cell figure in nearest h

Re: Automatically add required decimal figure to make destination cell figure in nearest h

Re: Automatically add required decimal figure to make destination cell figure in nearest h

Re: Automatically add required decimal figure to make destination cell figure in nearest h

Re: Automatically add required decimal figure to make destination cell figure in nearest h

Thread Information

Users Browsing this Thread

Similar Threads

VBA: Show Subtracted Figure In Cell When Cumulative Figure Is Entered

[SOLVED] Using Linear Regression to predict a future event / performance figure / speed figure

[SOLVED] trying to figure out how to grab an intersecting cell automatically

[SOLVED] How to insert sub-caption for figures? figure 1, figure 2-a, figure 2-b, figure 3, ...

[SOLVED] Highlight cell and it takes the figure within in away from another figure

Returning a figure if the destination cell fits a critera?

Calculating monthly sales figure required to make annual turnover figure

Bookmarks

Bookmarks

Posting Permissions