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
|