View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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.