View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi Susan

here's one option

=IF(AND(A1+A2=2.96,A1+A2<=2.99),A1+A2,ROUND(A1+A2 ,0))

Cheers
JulieD


"SusanN" wrote in message
...
need a formula: 2 cells w/ 2 decimals each, total = whole # except if
answers are between 2.96 - 2.99 range, does not want them to round up to
whole #