Date formula help

[jb133]

Hi guys,

I am working on a formula to show what the late fee needs to be depending on date rent was paid. I go a formula to do that, but i am struggling to get a 60 dollar value for a "no pay" of rent. below is a preview of my formula. I cant get it to populate when i place text in the cell K19.

https://drive.google.com/open?id=0ByIzBcfoqidJQkVxTHVvQm5LTkk (screen clip)

Thanks for any help.

 

[DebugGalpin]

Probably need the no pay if at the beginning of the formula as the would return a #VALUE so something like

=IF(K11="NO PAY",60,IF(K11-A11<=4,0,IF(K11-A11<=9,30,IF(K11-A11<=31,60,""))))

 

[jb133]

That did it THANK YOU!