| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
correct formula
(cell1)1254-(cell2)987=267 cell2)267/(cell1)1254= answer
I am looking for one formula to pick up this answer please help. so 1254 minus 987 equals 267, 267 divide by 1254 = answer % This is all revenue and budget based 987 is the actual 1254 is the budget and i am trying to add two colums for growth vs budget and growth vs prior year. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
correct formula
Using C1 for Cell1 and C2 for Cell2..
=(C1-C2)/C1 then format the cell as Percentage. Rick "shalamar1306" wrote in message ... (cell1)1254-(cell2)987=267 cell2)267/(cell1)1254= answer I am looking for one formula to pick up this answer please help. so 1254 minus 987 equals 267, 267 divide by 1254 = answer % This is all revenue and budget based 987 is the actual 1254 is the budget and i am trying to add two colums for growth vs budget and growth vs prior year. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
correct formula
Assuming A1=1254 and B1=267
=IF(AND(ISNUMBER(A1),ISNUMBER(B1)),(A1-B1)/A1,"") -- John C "shalamar1306" wrote: (cell1)1254-(cell2)987=267 cell2)267/(cell1)1254= answer I am looking for one formula to pick up this answer please help. so 1254 minus 987 equals 267, 267 divide by 1254 = answer % This is all revenue and budget based 987 is the actual 1254 is the budget and i am trying to add two colums for growth vs budget and growth vs prior year. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
correct formula
Thanks both of you for responding very helpful....
"Rick Rothstein (MVP - VB)" wrote: Using C1 for Cell1 and C2 for Cell2.. =(C1-C2)/C1 then format the cell as Percentage. Rick "shalamar1306" wrote in message ... (cell1)1254-(cell2)987=267 cell2)267/(cell1)1254= answer I am looking for one formula to pick up this answer please help. so 1254 minus 987 equals 267, 267 divide by 1254 = answer % This is all revenue and budget based 987 is the actual 1254 is the budget and i am trying to add two colums for growth vs budget and growth vs prior year. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
correct formula
Thanks both of you for responding very helpful....
"shalamar1306" wrote: (cell1)1254-(cell2)987=267 cell2)267/(cell1)1254= answer I am looking for one formula to pick up this answer please help. so 1254 minus 987 equals 267, 267 divide by 1254 = answer % This is all revenue and budget based 987 is the actual 1254 is the budget and i am trying to add two colums for growth vs budget and growth vs prior year. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Correct formula for this | Excel Worksheet Functions | |||
| What is the correct formula for IF C5 = Y, then L5 *.06? | Excel Worksheet Functions | |||
| Need the correct formula | Excel Discussion (Misc queries) | |||
| Please Correct the formula | Excel Discussion (Misc queries) | |||
| How do I correct this formula? | Excel Worksheet Functions | |||
Linear Mode
