# I need an exception formula

#### sllafleur

##### New Member
This is what I am trying to do. I have 4 core sheets that I input information into and it automatically calculates in the "monthly" and "quarterly" sheets. Right now, I place a tally mark in everyday the volunteer firefighter went to a call. Somedays they have one and some days they have five. I need to incorporate the letter "L" for a particular call because they get paid less for that call than all the others.

This is the formula I am using right now
=SUM(I4*10) This formula is on the 4th quarter percentages tab which is the final tab for the 4th quarter and it calculates everything from the OCT-DEC in each month folder together.

I4 line is adding all fires, meeting, and events together and multiplying by \$10. The other call I was referring to only receives \$5.00. So I am needing to know how I can incorporate that into my current spreadsheet.

Thank you and I hope I didn't confuse y'all
Here is a visual of what the worksheet looks like.

### Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

#### Dave87

##### Board Regular
can you provide the data in xl2bb if not, can you provide another screenshot showing the row and column labels so people know where I4 is.
Its always a good idea to show what answers you expect to get so maybe fill in the first few rows manually before sharing

#### beginvbaanalyst

##### Board Regular
It sounds like you need an IF statement.
There isn't enough information to see in order to write it though.
Can you provide some data in the cells that usually have it?

#### sllafleur

##### New Member
can you provide the data in xl2bb if not, can you provide another screenshot showing the row and column labels so people know where I4 is.
Its always a good idea to show what answers you expect to get so maybe fill in the first few rows manually before sharing
This sheet just calculates everything

from these sheets
and these sheets record

everything from these sheets

So I need to be able to put an "L" inside these cells instead of a tally mark and excel immediately calculate the change or have excel recognize when I have two tally marks and an "L" like this

I really hope this makes sense now

#### beginvbaanalyst

##### Board Regular
Just to confirm your SEPT screenshot is what your database is set up like for OCT, NOV, and DEC?
Then your Rows going down from the screenshot for SEPT go like # fires made - inside, # fires made - outside, # meetings made, events?
Or do the rows represent each individual? (I assume it's this answer).
The tally marks"|" represent a \$10 payout and the L represents a \$5?
Just so I have this right, First row had a payout of \$90?

#### sllafleur

##### New Member
Just to confirm your SEPT screenshot is what your database is set up like for OCT, NOV, and DEC?
Then your Rows going down from the screenshot for SEPT go like # fires made - inside, # fires made - outside, # meetings made, events?
Or do the rows represent each individual? (I assume it's this answer).
The tally marks"|" represent a \$10 payout and the L represents a \$5?
Just so I have this right, First row had a payout of \$90?
The screenshot is how you perceived it. The rows represent each individual. Yes, on the last two

Replies
0
Views
84
Replies
9
Views
231
Replies
2
Views
50
Replies
16
Views
145
Replies
0
Views
59