Forum Discussion

lambo_90's avatar
lambo_90
Occasional Reader
Mar 06, 2026

Want to add a minus number, alongside the existing formula

Hi all,
I have here a handicap calculator that's primarily used for tenpin bowling and I would like to add an enable / disable (with Yes or No) a Minus Handicap along with the existing formula for each cell (in columns B, E, H & K), plus the option to adjust the percentage to affect only the minus numbers.

Hope it all makes sense.

Thanks in advance.

 

excel
Formulas and Functions

1 Reply

  • Olufemi7's avatar
    Olufemi7
    Iron Contributor
    Mar 06, 2026

    Hellolambo_90​, Wrap your existing formula in an IF so the minus handicap only affects negative results.

    Assume:
    M1 = Yes/No to enable
    M2 = percentage adjustment (e.g., 0.1 for 10%)

    IF version:

    =IF($M$1="Yes",IF(ExistingFormula<0,ExistingFormula*(1+$M$2),ExistingFormula),ExistingFormula)

    LET version (Excel 365/2021):

    =LET(x,ExistingFormula,IF($M$1="Yes",IF(x<0,x*(1+$M$2),x),x))

    Apply to columns B, E, H, K.

    IF documentation
    h t t p s://support.microsoft.com/office/if-function-nested-formulas-and-avoiding-pitfalls-0b22ff44-f149-44ba-aeb5-4ef99da241c8

    LET documentation
    h t t p s://support.microsoft.com/office/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999