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

IF formula
Logitech formula vibration feedback wheel driver - Download - Drivers
Excel grade formula - Guide
Number to words in excel formula - Guide
Date formula in excel dd/mm/yyyy - Guide
Credit summation formula - Guide

1 response

Answer 1 / 1

aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 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

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!