Help for =if(left(A1,3="Yes",Value(Right(A1,1),0))

[kskhan]

Dear Masters,

Your valuable help is required to solve the issue I have in the formula above that if A1 (contains Yes-1) left(A1,3=yes then Right(A1,1) should come otherwise 0. I've applied the formula as =if(left(A1,3="Yes",Value(Right(A1,1),0)) but getting error.

Sorry if I'm unable to explain here, pls find the attached screenshot of the formula.

Best Regards,
Kashif

[shg]

Welcome to the board.

	A	B	C
1	Yes-1	1	B1: =IF(LEFT(A1,3) = "Yes", --RIGHT(A1), 0)

[sandy666]

maybe:

Please Login or Register  to view this content.

[shg]

Or

=(LEFT(A1,3)="Yes")*RIGHT(A1)

[kskhan]

Thanks Boss It Works Perfectly. May I know why do we need to write Right as --Right?

Regards,
Kashif

[Shareez Saleem]

IF(LEFT(A1,3)="Yes",CONCATENATE(LEFT(A1,3),RIGHT(A1,1)),0)

[kskhan]

Thanks to everyone for the Great Help.
You Guys Rocks. Stay Blessed & Thanks again.

Regards,
Kashif

[kskhan]

Gents,

Now the =Sum(B1:B225) Formula is not working on the conditional column .

[sandy666]

result of RIGHT(A1) or RIGHT(A1,1) is treated as text so SUM() will ignore text values
--RIGHT(A1) is treated as number (the same 1*RIGHT(A1) or 0+RIGHT(A1) )
use formula from #2

[kskhan]

Thanks a lot Sandy, Got it & worked perfectly.

[sandy666]

You are welcome.

If problem is resolved mark thread as solved and add star to person(s) who helped you. Thank you

[kskhan]

Sandy Today is my first day here so can you please guide me for this also.
Sorry for keep disturbing you.

[sandy666]

every post has star on the left bottom side,
solved thread - go to your first post , to the right side over your first post . there is Thread Tools, click and mark Solved.
btw. next time be more descriptive with your full problem not only with the part of.

[sandy666]

Now OK and thanks for the feedback

[kskhan]

Thanks for The Support & Ur Time
You deserves 5 Stars

[sandy666]

It's nice, thanks