Previous Topic Next Topic

Copying formulas

Closed
jmp - Oct 15, 2009 at 07:54 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 15, 2009 at 08:23 PM
Hello,
I created a spreadsheet where column B will multiply a value from column A's cell by 1.5. If there is no value in the A cell I need it to appear blank. Right now if there is no value I get a value of 1.5. Also, I need the total of the values at the end of the column.

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 15, 2009 at 08:23 PM
You have not mentioned what formula you usesd in B.
suppose you have A1 value in B1 type this formula
=A1*1.5
if there is value in A1 it will mutiply A valued by 1.5
if there is no value in A1 it will give zero.

try a few experiments.

You can even copy B1 down.

is this ok. if so confirm