98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2007 - does a cell have a number in it? (for formula)
Excel 2007 - does a cell have a number in it? (for formula)
Resolved · Low Priority · Version Standard
Wed 12 Mar 2008, 15:29Delegate Martin said...
Martin has attended:
Excel Advanced course
Excel Intermediate course
Excel 2007 - does a cell have a number in it? (for formula)
Is there a way of asking if a cell has a number in it as part of a formula? For example, column C has either a number or text in it; if there is a number in the cell I want to add it to my formula, if not I want to ignore it. i.e. =IF(C5 is a number, sum(B5+C5), sum(B5))
Thu 20 Mar 2008, 09:22Trainer Rajeev said...
RE: ISNUMBER is the solution to find if a cell has number or not
Dear martin
Thank you for attending Excel Course. I hope you enjoyed teh training.
The way you can do this calsulation is by mixing ID, AND and ISNUMBER.
Please refer to the excel file that I have uploaded with this post. I hacve saved it in Formula view so that you can easily see what function I have put in Cells D2: D5.
e.g. In Cell D2 teh function is
=IF(AND(ISNUMBER(B2), ISNUMBER(C2)),B2+C2, B2)
If you want to see the normal number view then please use the short cut key CTRL + ` ( this is situated below the ESC key on the keyboard).
I hope you find this useful.
If this has helped in resolving your query then I would request you to please mark the post as RESOLVED.
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
Attached files...
ISNUMBER Calculation.xls
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Some examples of CTRL key shortcuts in Excel 2010Did you know that the old CTRL key shortcuts haven't changed from previous versions of Excel to the 2010 version? |
