Is there a way to test a formula result in excel and type it only once all within one cell and not using a user defined function

0 votes

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 in Others by Kithuzzz
• 34,760 points
72 views

1 answer to this question.

0 votes

Use the Let function:

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

I hope this helps you.

answered Jan 9 by narikkadan
• 59,740 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

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

answered Sep 23, 2022 in Others by narikkadan
• 59,740 points
1,713 views
0 votes
1 answer

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

answered Oct 2, 2022 in Others by narikkadan
• 59,740 points
275 views
0 votes
1 answer

Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
• 59,740 points
345 views
0 votes
1 answer

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

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
271 views
0 votes
1 answer

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

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

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
530 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

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

Feb 17, 2022 in Others by Edureka
• 13,630 points
262 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

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

answered Feb 18, 2022 in Others by gaurav
• 22,970 points
302 views
0 votes
1 answer

Is there a way to hide excel formula using Apache POI

In Excel, hiding formulae is a feature ...READ MORE

answered Oct 11, 2022 in Others by narikkadan
• 59,740 points
292 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP