# Calculate cell if number [not text]

1. ## Calculate cell if number [not text]

I need to carry out some calculations on over 50,000 cells. 'Each record' consists of a unique reference, followed by 10 cells [columns] which either contain numbers or text. I wish to change only the cells containing numbers. Is there a non VBA way to do this?
David

2. Originally Posted by davidthegolfer
I need to carry out some calculations on over 50,000 cells. 'Each record' consists of a unique reference, followed by 10 cells [columns] which either contain numbers or text. I wish to change only the cells containing numbers. Is there a non VBA way to do this?
David
Hi David,
how to you wish to " change " those cells?
Could you post an example of what you are trynig to do?

3. I hope this example helps

Ref123 N/A N/A 1798 1690 1540 1300 1109 999 875 779

5%

Result for record + 5%

Ref123 N/A N/A 1888 1775 etc etc etc ...... ..... .....

I need a formula that will transfer text to the new location of if a number will carry out a percentage uplift. Say 5%. This will in facr be a lookup from a table.

I hope this helps.
My thanks
David

4. To answer one part of your question, raising numbers with a percenatge can be done as follows :
in an empty cell input how much you want the values increased ( say 1.05)
Copy this cell
Select the rows for which the values must be raised
Right-Click
Select " Paste Special"
Check Multiply
OK
All numbers are now increased by 5%

HTH

5. Thank you. I use quite complicated uplift tables etc. to do this. My problem is that there are about 2,000 cells containing N/A or Refer throughout the database. Applying the calculation to EVERY cell means that I corrupt the text cells and have to manually lookup and write over them.

I was hoping to construct a test to each cell before I apply the % uplift.

If text , write text to new cell. If number, apply %, write new value to the new cell.... kind of thing.

Thanks

David

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1