Excel IF/OR formula question

[Fritz]

Thanks again for all your inputs.

I'm not that well versed (duh) in Excel. I normally use it for simple database listing functions.
I am kind of floundering thru it to do these (prolly) simple logic & math functions/formulas.
But the syntax tangles me and the internal help doesn't seem very helpful to the lay person.

I thank my lucky stars I got this far without a diploma.