Formulas
 

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

Formulas
 

=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

Formulas
 

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


If Budget column is B and Actual is C, you could use something like this:

=IF((C1-B1)/C110%,(C1-B1)/C1,"OK")

this will display OK if Actual column is under 10% then Budget column;
instead you could use:

=IF((C1-B1)/C110%,(C1-B1)/C1,"-")

this will display "-" (without quotes) if Actual column is under 10% then
Budget column; instead you could use:

=IF((C1-B1)/C110%,(C1-B1)/C1,"")

this will display a blank if Actual column is under 10% then Budget column.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Formulas
 

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