# Need help evaluating a cell and returning a different result depending on the findings

1. ## Need help evaluating a cell and returning a different result depending on the findings

I have 2 formula's that work well independantly but I don't know how to join them so that you can look at the first number in one cell and return a different value depending on what that first number is. I am obviously new to this and was lucky to make the two work independantly. Can someone help? Here are the two that work fine independantly:

=IF(LEFT(A1,1)="7",8250&RIGHT(A1,4)," ")

=IF(LEFT(A1,1)="2",833&(A1)," ")

The end result should be that if cell A1 has the number 73521 then I want this new field to show 82503521 but if cell A1 has the number 23012, I want this field to show 83323012.

Thank you

2. ## Re: Need help evaluating a cell and returning a different result depending on the findings

Hello there,

This should do it.

``Please Login or Register  to view this content.``

3. ## Re: Need help evaluating a cell and returning a different result depending on the findings

Do you mean like this?

``Please Login or Register  to view this content.``

4. ## Re: Need help evaluating a cell and returning a different result depending on the findings

I Love you all. I thought I had done this but I must have missed a parenthesis or a comma or something. I cut and pasted yours and it works perfectly. Thank you, Thank you. This will save a ton of time.

5. ## Re: Need help evaluating a cell and returning a different result depending on the findings

@ Cardamone

Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

There are currently 1 users browsing this thread. (0 members and 1 guests)