Thread: specific rounding of formulas which may need to include an IF stat
View Single Post
  #3   Report Post  
Ola
 
Posts: n/a
Default
Hi,

Here is one solution:
=IF((A1-TRUNC(A1/10,0)*10)<5,5,9)+TRUNC(A1/10,0)*10

Ola

Reply With QuoteReply With Quote