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 #
|