View Single Post
  #8   Report Post  
swatsp0p
 
Posts: n/a
Default

Hello, SusanN:

Assuming your two numbers are in A1:A2, use this formula:

=IF(AND(SUM(A1:A2)2.95,SUM(A1:A2)<3),SUM(A1:A2),R OUND(SUM(A1:A2),0))

Format this cell as General:

2.49 will return 2
2.50 will return 3
2.95 will return 3
2.96 will return 2.96
....
2.99 will return 2.99
3.00 will return 3
etc.

HTH

Bruce