excel does

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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)

resolvedResolved · Low Priority · Version Standard

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

Attached files...

ISNUMBER Calculation.xls

RE: ISNUMBER is the solution to find if a cell has number or not

Hi Rajeev,

That is exactly what I was looking for - thanks for the quick response.

Regards,

Martin


 

Excel tip:

Some examples of CTRL key shortcuts in Excel 2010

Did you know that the old CTRL key shortcuts haven't changed from previous versions of Excel to the 2010 version?

They remain exactly the same:

Ctrl+B for bold
Ctrl+I for italics
Ctrl+P to Print
Ctrl+S to Save

View all Excel hints and tips


Server loaded in 0.08 secs.