Another If Statement Calc Issue
I need help with this IF statment calc...
If ( DisabledQuesion = "YES" or sixtyandover = "YES" and (RentMortgage > 458); RentMortgage; -0 )
What im trying to accomplish is... if the person is disabled or age sixty and over....subtract the full rent or mortgage amount they are paying. If they are not disabled and age sixty and over.... then the max deducation for rent or mortgage can only be 458. Im Lost!