Skip to main content
terryhendicott
terryhendicottAnswer
21-Topaz II
Jul 23, 2025 2:30 PM UTC

Capture.JPG

Cheers

Terry

View in thread

4 replies

terryhendicott
terryhendicott21-Topaz IIAnswer
21-Topaz II
Jul 23, 2025 2:30 PM UTC

Capture.JPG

Cheers

Terry

Translate
    SFares14-AlexandriteAuthor
    14-Alexandrite
    Jul 23, 2025 3:03 PM UTC

    Thank you so much, Terry!

    Translate
    LucMeekes23-Emerald V
    23-Emerald V
    Jul 23, 2025 2:48 PM UTC

    This should do it. You may need to recalculate the sheet.

    Note that you don't need the IF statements. The function linterp will do extrapolation from the last two points on either side of the range, so just extend the range with an extra point on either side...

     

    Success!
    Luc

    Translate
    SFares14-AlexandriteAuthor
    14-Alexandrite
    Jul 23, 2025 3:04 PM UTC

    Wonderful and I appreciate it. Thanks alot, Luc!

    Translate
    Terms & ConditionsAccessibility statement