Previous Topic Next Topic

IF formula

Solved/Closed
joan - Oct 29, 2009 at 10:54 AM
 joan - Oct 29, 2009 at 08:27 PM
Hello,
wondering if you can help me with excel

i need a formula that shows if A1 is starts with letter then give me a that first letter. If it starts with number then give me "Home"

thanks a lot

1 response

Answer 1 / 1
aquarelle Posts 7435 Status Moderator 491
Oct 29, 2009 at 06:38 PM
Hi,
Try with this formula :

=IF(ISNUMBER(A1),"Home",LEFT(A1,1))

Best regards
joan
Oct 29, 2009 at 08:27 PM
Thank you so much for helping me with my IF excel formula! This is the BEST site I ever found!

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses