Round number

[Tim Stoner]

Hi all
I use this formula to multiply a some cells how would I incorporate the round feature to round to 2 decimal points
=IFERROR(O23*N23,0) it is giving me a multi decimal place answer
I would just like a currency outcome such as $2.50 ( not show $2.50 but actual is $2.502323

Any help appreciated
Thank you

 

[shaowu459]

how about this one:
=IFERROR(ROUND(O23*N23,2),0)

 

[Tim Stoner]

how about this one:
=IFERROR(ROUND(O23*N23,2),0)

Wow
That was really quick
Many Thanks
Will try it

 

[Tim Stoner]

how about this one:
=IFERROR(ROUND(O23*N23,2),0)

Perfect
Thank you again

 

[shaowu459]

Wow
That was really quick
Many Thanks
Will try it

OK, please let me know if you have further queries on that.

 

[shaowu459]

Perfect
Thank you again

you are welcome