Thread: Round in an IF statement
View Single Post
  #1   Report Post  
heater
 
Posts: n/a
Default Round in an IF statement
Where does the Round go in the following formula:

=IF($C$19<5000000,500000,IF($C$195000000,(D52/$D$95)*$C$19))

I want it to round to the nearest 1,000.
Reply With QuoteReply With Quote