How to present multiplication result

Maybe:

=ROUND(114*84*96,0)

Or just use currency formatting with decimal places set to 0.

Ali proposed a solution with 3 different values ( thus three cells). What you used are two values squared ? What are A2, B2, etc.. A small sample would shed some light

Yes, as mentioned above, workbook, please.

As advised in the yellow banner at the top of this page, providing a sample workbook is a good idea.

HOW TO ATTACH YOUR SAMPLE WORKBOOK: Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen. Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

This will get the (unfathomable, to me!) result you want:

=ROUNDUP((A2*B2*ROUND((A2*B2)/100,0))/1000,0)

Many thanks for the help... not sure how to attach the spreadsheet (if someone can tell me how to)... but here is the data:

Art Calculator for painting on canvas

Side A
114

Side B
84

Square cm
9576 (A3*B3)

$ value per sq cm
95.76 (C3/100)

Read post #5 again, please - I explained how to attach a workbook in detail there.

Based on the above, I now have no idea what the issue is.

=A3*B3/100

???

No sign of it, sorry. Try again, please, and don't forget to submit.

In the meantime, what is missing from the attached mock-up? What am I not getting here?

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	A	B	C
1
2
3	114	84	95.76

Sheet: Sheet1

Has this been resolved now?

No, you didn't upload anything - I did. It's not your workbook, it's mine.

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.