I am trying to create a spreadsheet that will calculate mileage, example below. I want it to return a "-" if the mileage is waived, if the attendance cell is blank, or if the attendance cell is "N". If attendance is "Y", I want it to calculate the mileage. I am getting a 'false' response instead of the hyphen or a dollar amount. Where am I going wrong? In this example, $D$2 is where I have my mileage reimbursement rate parked.
Column C | Column D | Column E | Column F | Column G | Column H | |
Miles | Tolls | RSVP | Attended | Payable | Mileage | |
50 | 4.00 | Y |
| waived | ||
30 | 2.00 | N | Pay - check | |||
80 | Pay - Check | |||||
60 | Y | waived | ||||