Macro to calc an intersection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=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.
 
Back
Top