Formulas

J

Jill

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

Dave F

=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
 
F

Franz Verga

Jill said:
I need a formula that will do this:
Budget vs Actual...If Actual column is 10% more then budget column
show that value
Click to expand...


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

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

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

=IF((C1-B1)/C1>10%,(C1-B1)/C1,"-")

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

=IF((C1-B1)/C1>10%,(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
 
J

Jill

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

thanks
 
Top