Forum Discussion
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 e...
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