Thanks but I need it to look like this in the report
act budget Var
10 10
200 20 90%
300 400

thanks
--
jk


"Dave F" wrote:

=IF(Actual=Budget*1.10,Actual,Budget)

Example:

Actual is in A1 and Budget is in B1, so: =IF(A1=B1*1.1,A1,B1) (assumes if
Actual is not = to B1*1.1, you want B1 to appear instead. Otherwise replace
B1 with "": =IF(A1=B1*1.1,A1,"")

Dave
--
Brevity is the soul of wit.


"Jill" wrote:

I need a formula that will do this:
Budget vs Actual...If Actual column is 10% more then budget column show
that value
--
jk