IF problem

  • Thread starter Thread starter Mike Hanneke
  • Start date Start date
M

Mike Hanneke

I'm getting #VALUE! when using the following formula:
=IF(LEFT(RIGHT(A1,10),2)="1r","1row"),IF(LEFT(RIGHT(A1,10),2)="2r","2row","4
row")

I've used embedded IFs with success in the following formula:
=IF(RIGHT(C2,4)="00,0","no,no",IF(RIGHT(C2,4)="00,t","no,yes",IF(RIGHT(C2,4)
="el,0","yes,no","yes,yes")))

Any ideas?

Thanks,
Mike
 
Mike Hanneke said:
I'm getting #VALUE! when using the following formula:
=IF(LEFT(RIGHT(A1,10),2)="1r","1row"),IF(LEFT(RIGHT(A1,10),2)="2r","2row","4
row")

I've used embedded IFs with success in the following formula:
=IF(RIGHT(C2,4)="00,0","no,no",IF(RIGHT(C2,4)="00,t","no,yes",IF(RIGHT(C2,4)
="el,0","yes,no","yes,yes")))

Any ideas?

Thanks,
Mike
Click to expand...

You have a closing bracket in the wrong place (after "1row"), which means
that your IFs are not nested:
=IF(LEFT(RIGHT(A1,10),2)="1r","1row",IF(LEFT(RIGHT(A1,10),2)="2r","2row","4r
ow"))

A useful way of checking brackets is to go along your formula from the left,
counting up by one for each left bracket you pass and down for each right
one. I did this with your formula, and got back to zero after "1row", so I
immediately knew that nothing else was part of what had gone before.
 
I think you've got a misplaced close paren.

=IF(LEFT(RIGHT(A1,10),2)="1r","1row",
IF(LEFT(RIGHT(A1,10),2)="2r","2row","4row"))

(watch for line wrap--it's all one cell.)
 
Mike,

Just a misplaced bracket

=IF(LEFT(RIGHT(A1,10),2)="1r","1row",IF(LEFT(RIGHT(A1,10),2)="2r","2row","4row"))

You had a bracket after "1row" which was ending your if statement early.

Dan E
 
Mike,
You have an extra ) after "1row" in your first IF statement.

Good Luck,
Mark Graesser
(e-mail address removed)


=IF(LEFT(RIGHT(A1,10),2)="1r","1row",IF(LEFT(RIGHT(A1,10),2)="2r","2row","4row"))

----- Mike Hanneke wrote: -----

I'm getting #VALUE! when using the following formula:
=IF(LEFT(RIGHT(A1,10),2)="1r","1row"),IF(LEFT(RIGHT(A1,10),2)="2r","2row","4
row")

I've used embedded IFs with success in the following formula:
=IF(RIGHT(C2,4)="00,0","no,no",IF(RIGHT(C2,4)="00,t","no,yes",IF(RIGHT(C2,4)
="el,0","yes,no","yes,yes")))

Any ideas?

Thanks,
Mike
 
Back
Top