If Statement Not Working When Including Cells That Have Formulas

0 votes 
=if(a1>10,1,0)

The problem that I'm having is that cell A1 has a formula that generates a percentage. The formula above isn't giving the correct answer.

What am I doing wrong?

Oct 23, 2022 in Others by Kithuzzz
 • 38,000 points • 691 views

1 answer to this question.

0 votes

Try: 

=IF(VALUE(A1)>10;1;0)

I hope this helps you.

answered Oct 23, 2022 by narikkadan
 • 63,600 points

Related Questions In Others

0 votes
1 answer

How do I run a VBA Sub routine continuously when working in a Workbook and not only when the Workbook is opened?

on Thisworkbook, put: Private Sub Workbook_Open() Call checkPW(True) End Sub Then ...READ MORE

answered Jan 14, 2023 in Others by narikkadan
 • 63,600 points • 632 views
0 votes
1 answer

IF statement for a tax sheet does not work

Use vlookup() as that is much easier ...READ MORE

answered Mar 20, 2023 in Others by narikkadan
 • 63,600 points • 539 views
0 votes
1 answer

Check multiple cells in excel, move to next cell if null and if value found stop and return that value

Use this formula: =INDEX(FILTER(A2:D2,A2:D2<>""),1,1) INDEX returns the first value ...READ MORE

answered Mar 24, 2023 in Others by Kithuzzz
 • 38,000 points • 575 views
0 votes
1 answer

How to check if array is multidimensional or not?

Since the 'second dimension' could be just ...READ MORE

answered Nov 5, 2018 in Others by DataKing99
 • 8,250 points • 5,998 views
0 votes
1 answer

Excel COUNTIF formula

Please see MS Excel: COUNTIF Function (WS) You should ...READ MORE

answered Sep 29, 2022 in Others by narikkadan
 • 63,600 points • 808 views
0 votes
1 answer

Is there a maximum number of formula fields allowed in Excel (2010)

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE

answered Sep 30, 2022 in Others by narikkadan
 • 63,600 points • 897 views
0 votes
1 answer

Multiplying cells and sum then for a range

Use SUM() as an Array formula:  =SUM(IFERROR((AB22:AB1100 = ...READ MORE

answered Oct 2, 2022 in Others by narikkadan
 • 63,600 points • 1,112 views
0 votes
1 answer

INDEX formula in Excel, Top 10, repeats previous value

Try this formula in cell W4: =IF(V3=V4,INDEX(INDIRECT("I"&MATCH(W3,I:I,0)+1&":I26"),MATCH(V4,INDIRECT("R"&MATCH(W3,I:I,0)+1&":R26"),0)),INDEX($I$2:$I$26,MATCH(V4,$R$2:$R$26,0))) The calculation ...READ MORE

answered Oct 8, 2022 in Others by narikkadan
 • 63,600 points • 1,039 views
0 votes
1 answer

How do I avoid repeating long formulas in Excel when working with comparisons?

Try this: =IFERROR(EXP(LN(REALLY_LONG_FORMULA – threshold)) + threshold, 0) The ...READ MORE

answered Dec 15, 2022 in Others by narikkadan
 • 63,600 points • 548 views
0 votes
1 answer

Why this Excell formula that take the value of a cell and concatenate to the value or another cell is not working?

If J17's value is a true or ...READ MORE

answered Jan 10, 2023 in Others by narikkadan
 • 63,600 points • 582 views
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
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.