Thread: =IF(B25="",ROUND(O25,-2),"")
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nick C Nick C is offline
external usenet poster
  
Posts: 21
Default =IF(B25="",ROUND(O25,-2),"")
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