Need Help with Formula?

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I want to multiply every number in my B column by 1.3 with
the correct answer going in to c column. Not sure if i
explained this right having trouble with the language.

Thanks
Matt
 
Correct answer into a single cell or every corresponding cell where ther is data
in Col B.

Either, with your data in Col B starting B1, in C1 put =B1*1.3 and copy down, OR
in any single cell in Col C, put =SUM(B:B)*1.3
 
Matt,

In C1, enter =B1*1.3

and copy down column C

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
1. In column C, type the following formula:

=B5*1.3

Where:
B5 is the first cell in the B column that contains a number
* = multiply
1.3 = the multiplier

2. Copy this formula down to every cell in column C that has a number in
column B

If you think the 1.3 might change in the future, you may want to place the
1.3 in a separate cell somewhere and have the formulas in column C look to
that cell for the multiplier. For example:

1. Type 1.3 in cell F1
2. Repeat the steps above but use the following formula:

=B5*$F$1

The dollar signs insure F1 does not adjust when the formula is copied
down the C column.

Whenever the multiplier (1.3) needs to change, simply type a new number in
cell F1 and all of the formulas in column C will adjust.
 
Hey! Have you tried this:

Enter "=B1*1.3" in C1 cell and copy down?

Just a thought...

**surprised no one else thought of this**

:D :D :D
 
Josiah > said:
Hey! Have you tried this:

Enter "=B1*1.3" in C1 cell and copy down?

Just a thought...

**surprised no one else thought of this**
Click to expand...

Sorry, but 3 of us did, including the one you replied to.
 
LOL - I'm assuming he was being sarky given that all the previous replies said
the same thing - That's the joys of not using a forum that posts the timestamps,
as he would then have seen that all replies were posted at pretty much the same
time and would therefore have realised that they simply all crossed in the post.
 
Ken said:
*LOL - I'm assuming he was being sarky given that all the previou
replies said
the same thing - That's the joys of not using a forum that posts th
timestamps,
as he would then have seen that all replies were posted at prett
much the same
time and would therefore have realised that they simply all crosse
in the post.
Click to expand...

That's what I figured! I just couldn't resist...sorry!

:D;
 
Bob said:
Well I suppose that helped and yes, that is facetious also. *
Click to expand...

Just trying to have a little fun, Bob! No harm done...my answer was
correct (as well as the others!)...

Seeing all those same answers posted at the same time was just a little
humorous!

:)
 
You should hang around more, it happens all the time.

Apologies for coming over so officious, my reaction to not spotting it (Ken
did and I didn't!).

Bob

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top