nested If statements

[jsp33]

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	=IF(H2="waived","-",IF(F2=" ","-",IF(F2="N","-",IF(F2="Y",(C2*$D$2)+D2))))​	waived
30	2.00		N		Pay - check
80					Pay - Check
60			Y		waived

 

[Fluff]

How about

=if(h2="waived","-",if(f2="y",(C2*$D$2)+D2,"-"))

 

[Scott Huish]

Perhaps:
=IF(OR(H2="waived",F2<>"y"),"-",(C2*$D$2)+D2)

 

[jsp33]

How about

=if(h2="waived","-",if(f2="y",(C2*$D$2)+D2,"-"))

That worked, thank you!

 

[Fluff]

Glad we could help & thanks for the feedback.