I am trying to round a number up but I get a circular reference error. I am using =(E67/3.4)+D67 in cell D68. The cell shows 216.705 but I want it to show 217. Cell D67 is =SUM(D2:D66). Cell E67 is +SUM(E2:E66). When I change cell D68 to =(E67/3.4)+D67+ROUNDUP(M66,0) then I get a circular error message. Can you help? Is there an easier way to just round up my number in cell D68? Thanks, jhclaws.......
hi and welcome to the forum.....try this
=ROUNDUP(E67/3.4)+D67,0)
untested
HTH
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Hi,
What's in M66 since this is the only cell that's creating a circular reference.
Why not upload the workbook since you have it rather than just describing what's in the cells. Many of us are less than inclined to create workbooks from scratch when you've already done it.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
I tried that but I got "You've entered too few arguments for this function." I will try to upload the spreadsheet/workbook so you can test it. I just want cell D68 to show a rounded up whole number like 217. I am using this cell to make more calculations on the TAB "Andy's Receipt" .... thanks again for your help ...JHCLAWSOriginally Posted by judgeh59
Hi jhclaws
When you are getting any Circular Reference Error it means you are trying to do something repetitive.
If you do not want this error, just simply click on the Enable Iterative Calculation option.
How to do this, here are the steps
1. Excel Options
2. Click on Formulas
3. Within Calculation Options, you will find the option Enable Iterative Calculation . Please click on the check box.
Doing following steps you will not get the error.
___________________________________________________________________________________________________________________________________________
if something has helped, please click * to add to reputation.
“I have not failed. I've just found 10,000 ways that won't work.”
― Thomas A. Edison
Judge left out a (...
=ROUNDUP((E67/3.4)+D67,0)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sorry, thats not the way to fix this. You need to identify the cause and correct it here. Leaving a circ err can cause all sorts of strange unexpected answers to pop up.
The reason for a circ error is normally a logic error as in when you try to reference A1 in A1, or where yoy say that A1=B1 and then you say that B1 = A1.
Hi FDibbins
Apologies for that I had to dig in to the logic error.
I replied this because even I had faced same problem. So I Enabled the Iterative option.
From then I didn't had any error. But I will check now
___________________________________________________________________________________________________________________________________________
“I have not failed. I've just found 10,000 ways that won't work.”
― Thomas A. Edison
@ shy, no, you still had the error, it just wasnt telling you it was there now
First I will look even that and this.
Thanks a lot for this reply
Hi,
The workbook you uploaded is inconsistent with your original post. For instance there is nothing in D68.
I'm guessing it's D44 that you are wanting to round, in which case, and as others have mentioned:
Formula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks