| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to calc an intersection
I need to write a macro that calculates fringe in a
spreadsheet whenever Forecast and Fringe intersect. A B C D Jan Feb Mar Account Actual Forecast Forecast 1 Salary 100,000 95,000 92,000 2 Fringe 28,000 +95,000* .2 +92,000*.2 The formula that I need in C2 and D2 is Salary * FringeRate. How can I write a macro that calculates this ... Whenever Fringe and Forecast intersect calculate fringe in that cell. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to calc an intersection
=IF(AND($A4="Fringe",C$2="Forecast"),C$3*0.2,"")
enter in C4 and copy paste elsewhere. This assumes that row 1 and 2 have the month and account lines and your actual data starts in line 3 for salary and 4 for fringe. wrote: I need to write a macro that calculates fringe in a spreadsheet whenever Forecast and Fringe intersect. A B C D Jan Feb Mar Account Actual Forecast Forecast 1 Salary 100,000 95,000 92,000 2 Fringe 28,000 +95,000* .2 +92,000*.2 The formula that I need in C2 and D2 is Salary * FringeRate. How can I write a macro that calculates this ... Whenever Fringe and Forecast intersect calculate fringe in that cell. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to calc an intersection
I need to do it via a macro. For other reasons, I can't
have a formula in those cells. -----Original Message----- =IF(AND($A4="Fringe",C$2="Forecast"),C$3*0.2,"" ) enter in C4 and copy paste elsewhere. This assumes that row 1 and 2 have the month and account lines and your actual data starts in line 3 for salary and 4 for fringe. wrote: I need to write a macro that calculates fringe in a spreadsheet whenever Forecast and Fringe intersect. A B C D Jan Feb Mar Account Actual Forecast Forecast 1 Salary 100,000 95,000 92,000 2 Fringe 28,000 +95,000* .2 +92,000*.2 The formula that I need in C2 and D2 is Salary * FringeRate. How can I write a macro that calculates this ... Whenever Fringe and Forecast intersect calculate fringe in that cell. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MACRO can I calc just one line? | Excel Discussion (Misc queries) | |||
| 2Q:Indirect worksheet selection in macro, Calc off for specific sh | Excel Discussion (Misc queries) | |||
| Calc cost pro rata (nested IF's and macro to find empty row) | Excel Worksheet Functions | |||
| auto calc on, but have to edit (f2) cells to force re-calc..help! | Excel Worksheet Functions | |||
| calc locks up after running a macro that moves sheets to a new fil | Excel Discussion (Misc queries) | |||
Hybrid Mode
