I am creating an expense sheet, and when it comes to meals, some claim what they actually paid and others claim the per diem amount.
I'm having a hard time to figure out how to use the max function to give me the actual amount spent or the per diem but not going over $40.00
Here is how its set...