Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |