How is Excel Arriving at This No?

Could anyone help me understand why Excel is arriving at -16? I'll try attaching workbook in the next post as it's not letting me attach it with this post.

In cell C9 I was hoping to see 35, but I have no idea why it's returning -16?

A6 = 6.515
A9 = 4.800
B8= 18

Please Login or Register  to view this content.

If results to True,
Then I'd expect 6.515/4.80= 1.357
Then I'd expect it to roundup = 2
Then *18 = 136
Then -1= 35

I'm about to try array formulas but quite embarassed I can't understand basic precedence right.

No sorry, can't attach workbook, in 'Advanced' I get a little yellow box on clicking but can't load an uploading window.

To attach an Excel file to your post,

• desensitize data
• remeber that your example should reflect structure and type of data
• click Go Advanced,
• scroll down until you see Manage Attachments,
• click that and select Browse,
• select your file and click Open,
• click Upload and you will see your attachment below Upload Files from a website
• click Close this window,
• click Submit reply

After that you should see attachment in your post

Thanks so much Glenn, I've been staring at it for over an hour trying all sorts of combinations over and over again.

Thank you all for your posts; most helpful. Yes mrShorty I've been watching many, many ExcelIsFun tutorials they are awesome! Made approx 50 pages of notes and was staring through my order of precedence but did not think of splitting to the right.
Couldn't for the life of me figure it out though, so thank you all again for your input.