From: james on 19 Apr 2010 10:38 Hi all, looking for help with a formula, I have column G which is money recieved, ideally this should be €40 in each cell, however sometimes it is more or less, so i have column H which is the difference between money recieved and €40, eg if €35 recieved, shows -€5 if 45 recieved shows €5. I had =G26-40 however this will show -€40 when there is no entry in the cell G. ho do i show this as blank or 0 when no entry? Also how do i repeat formula for all cells in a column? Thanks James From: Eduardo on 19 Apr 2010 10:46 Hi, =if(G26="","",G26-40) "james" wrote: > Hi all, looking for help with a formula, > I have column G which is money recieved, ideally this should be €40 in each > cell, however sometimes it is more or less, so i have column H which is the > difference between money recieved and €40, eg if €35 recieved, shows -€5 if > 45 recieved shows €5. > I had =G26-40 however this will show -€40 when there is no entry in the > cell G. > ho do i show this as blank or 0 when no entry? > > Also how do i repeat formula for all cells in a column? > Thanks > James  |  Pages: 1 Prev: Script to insert RowNext: why are my column headers numbers instead of letters?