Thread: =IF(B25="",ROUND(O25,-2),"")
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_951_] Rick Rothstein \(MVP - VB\)[_951_] is offline
external usenet poster
  
Posts: 1
Default =IF(B25="",ROUND(O25,-2),"")
Give this formula a try...

=MAX(1000,ROUND(O25,-3))

Rick


"Nick C" wrote in message
...
I am trying to write a formula which rounds O25 to the nearest thousand,
with
a minimum of one thousand.

So 330 would be 1000
1565 would be 2000
1321 would be 1000

Thanks in advance

Nick

Reply With QuoteReply With Quote