"Robert" wrote
.....
... (Believe there's a typo in the value for C8 in the original
post: C8's computed value should be 70, not 60)
....
Actually, No, it is supposed to be 70 ...

That means the suggested formulas in cols C to E returned correctly, yes?
....
I would like to elaborate more about what I am trying to accomplish
with these formulas..

Were the suggested formulas for cols C to E what you were after,
or is it something else ?

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----