Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Find all cells with a number and mulitply
How can I find all cells in a sheet that are a number
greater than zero and multiply each one by a number? IE: the number to multiply by is 1.2 A1 Tom A2 25 A3 0 G12 Bob G13 25 I want to programatically (without using a macro) find cells a2 and g13 only and multiply them by 1.2 Thanks in advance for your help. Jim |
#2
|
|||
|
|||
Jim,
As long as you don't have any negative numbers, it doesn't matter about being 0 (0*n=0) or being text. Try this Put 1.2 in a spare cell and then copy it Select all the cells Goto menu EditPastespecial Click the Multiply option OK out Now clear the cell with 1.l2 in -- HTH RP (remove nothere from the email address if mailing direct) "Jim" wrote in message ... How can I find all cells in a sheet that are a number greater than zero and multiply each one by a number? IE: the number to multiply by is 1.2 A1 Tom A2 25 A3 0 G12 Bob G13 25 I want to programatically (without using a macro) find cells a2 and g13 only and multiply them by 1.2 Thanks in advance for your help. Jim |
#3
|
|||
|
|||
Try the following array formula...
=SUM(IF(ISNUMBER(A1:G13),A1:G13*1.2)) ....confirmed with CONTROL+SHIFT+ENTER. Hope this helps! In article , "Jim" wrote: How can I find all cells in a sheet that are a number greater than zero and multiply each one by a number? IE: the number to multiply by is 1.2 A1 Tom A2 25 A3 0 G12 Bob G13 25 I want to programatically (without using a macro) find cells a2 and g13 only and multiply them by 1.2 Thanks in advance for your help. Jim |
#4
|
|||
|
|||
While you can multiply your text values by 1.2 and
nothing will happen, if you really want to just select numerical values: 1. Key 1.2 into an open cell. 2. Copy that cell. 3. Press Ctrl+A. 4. Press F5 Special click "Constants" and uncheck everything below except "Numbers". 5. Edit Paste Special and click "Multiply". HTH Jason Atlanta, GA -----Original Message----- How can I find all cells in a sheet that are a number greater than zero and multiply each one by a number? IE: the number to multiply by is 1.2 A1 Tom A2 25 A3 0 G12 Bob G13 25 I want to programatically (without using a macro) find cells a2 and g13 only and multiply them by 1.2 Thanks in advance for your help. Jim . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|