round formula

sburkhar

Active Member
How do I round the result of this formula to 4 decimal points?

=IF(B9="Wire",' WIRE MATRIX'!L9,IF(B9="Other","",C9*M9))

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
=IF(B9="Wire",' WIRE MATRIX'!L9,IF(B9="Other","",ROUND(C9*M9,4)))

Awwww................I had it right and didn't trust myself. Thanks!

Awwww................I had it right and didn't trust myself. Thanks!

You're welcome.

Replies
4
Views
147
Replies
2
Views
1K
Replies
8
Views
444
Replies
9
Views
217
Replies
5
Views
365

1,196,318
Messages
6,014,617
Members
441,832
Latest member
tony tessman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back