=ROUNDUP(ROUND(SUM(I8*F8))*2,0)/2)
For one reason or another it's not working and I can't figure out what the issue is. Thoughts? Please and thank you for the help.
=ROUNDUP(ROUND(SUM(I8*F8))*2,0)/2)
For one reason or another it's not working and I can't figure out what the issue is. Thoughts? Please and thank you for the help.
According to the help file (https://support.office.com/en-us/art...3-db171d0c42a7 ), the second "num_digits" argument is required. What you have typed/pasted into your post does not have a "num_digits" argument =ROUNDUP(ROUND(SUM(I8*F8))*2,0)/2,num_digits). If what you have typed is exactly what you are trying to enter into Excel, then you need to decide how many digits the ROUNDUP() function should round to and enter it in the "num_digits" argument.
Originally Posted by shg
Given you don't say what the formula needs to achieve its a guess
=ROUNDUP(ROUND(SUM(I8*F8),0)*2,0)/2
Please see attached. There is a Long Form Calculator and a Short Form Calculator. In the yellow box of the Short Form Calculator is a Total (158.5), cell H13. This is the number that I'm trying to get to appear in cell J8. I thought I was somewhere close with the Formula I provided, but I am unable to complete it.
I probably have one too many "Rounds" in there at second glance. So =ROUNDUP(SUM(I8*F8)*2,0)/2 would be the starting point. TKs.
i don't understand this formula:
=SUM(I8*F8)*2,0)/2
Last edited by bhenlee; 09-14-2018 at 11:15 AM.
If I've helped U pls click on d *Add Reputation
Think I have it all sorted it. It was the "Inches Per Degree" formula that needed adjusting.
Inches Per Degree=ROUNDUP(E8*PI()/360,2)
Around Wall=ROUNDUP(SUM(I8*F8)*2,0)/2
Thanks to everyone for letting me confuse them for a bit and for the help.
Hi
In formula Around Wall=ROUNDUP(SUM(I8*F8)*2,0)/2 you do not need the function SUM
See the file
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks