Given the formula:

``` =if(a1+b2+c4+g3+b4>10,"No",a1+b2+c4+g3+b4)
```

Is there any way to not have to type the same a1+b2+c4+g3+b4 twice and have the results be either "No" or the value of a1+b2+c4+g3+b4?

Something like:

``` =???(a1+b2+c4+g3+b4,">10","No")
```

When I want to test a value, I constantly have to enter the same formula twice. If the value meets certain criteria, the results are one thing; otherwise, they are the formula's results.

Jan 9, 2023 in Others 547 views

## 1 answer to this question.

Use the Let function:

`=LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value))`

I hope this helps you.

• 63,720 points

## Is there a way to remove password in a Excel file (.xls) using shell in Linux with known password?

Dig into the Excel documentation for the ...READ MORE

## Is there a function in excel to automatically calculate age using date of birth?

Try  =INT((YEARFRAC(TODAY(),B3,1)))  Where cell B3 contains a date like ...READ MORE

## Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

## Is there a way in Microsoft Excel to give specific bins different bin widths when making a histogram plot?

Excel built-in histogram tool only allows equal ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE