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))
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
ISNUMBER Calculation.xls
