Hi,

I've been goind around with this and am not sure how to accomplish it. I am
trying to compare two values, but I want to allow a variance of plus or minus
the value in Gross Up I2. The formula used depends on whether G7 begins with
"Pro". What I have only works for a positive number, not a negative. How
would I do this?

=IF(LEFT($G$7,3)="Pro",IF(SUM($G$11-SUM('GL Line Items'!$E$10/'Gross Up'! _
F2*$B$3))'Gross Up'!I2,"Totals do not match",""),IF(SUM($G$11-'GL Line
Items'! _
$E$10)'Gross Up'!I2,"Totals do not match",""))
--
Thanks for your help.
Karen53