round to the nearest dollar ( Rand )

[Onesock]

Hi Guys

Could someone please help me with the formula to round (up or down ) to the nearest dollar ( or Rand from South Africa ) . ie no cents.

Thanks

Onesock

[dogberry]

Hi

Use the round function ie round(A1,0) if you want one decimal place change the 0 to 1

Chris

[Onesock]

Got it !!!

[Onesock]

Thanks dogberry

All sorted -

[dogberry]

Hi

Your welcome

Chris