Formula, Excel, Different daily rate, Weekend, Weekday

Hi gurus,

I seem having an issue finding a formula based on the day of the week.

Mon to Fri rate: 850
Sat rate: 1275
Sun rate: 1700

=IF(WEEKDAY($B2)=6,$D2*1275),IF(WEEKDAY($B2)=7,$D2*1700),$D2*850)

Thank you
dude6571