Search : in
By :

Copying formulas

Last answer on Oct 16, 2009 1:23:44 am BST jmp, on Oct 16, 2009 12:54:42 am BST 
 Report this message to moderators

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.

Configuration: Windows XP Internet Explorer 7.0

Best answers for « copying formulas » in :
Turning off volume shadow copy ShowTurning off volume shadow copy Short intro How to disable? How to edit the disk space allocated to shadow? Disable the "Previous versions" Short intro Shadow Copy Volume or Snapshot Service or VSS, is a feature firstly embedded...
Copy/Paste problems when using Firefox ShowCopy/Paste problems when using Firefox Pushow Adware Extensions It happens that sometimes, Firefox refuse to copy/paste items. Two assumptions can be made: Pushow Adware You have been infected by an adware, named pushow**.dll...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Download CopyTrans Suite ShowCopyTrans Suite is a set of practical tools for your Ipod or Iphone. It contains: · CopyTrans v2.37 · CopyTrans Photo v2.21 · iLibs v1.13 · iCloner v1.07 · CopyTrans Doctor v1.015 · CopyTrans Manager v0.720 · SyncGuardian...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...

1

 venkat1926, on Oct 16, 2009 1:23:44 am BST

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

Reply to venkat1926