Changing Zero values and adding or subtracting small amounts from values in other cells

Dear Sir / Madam,

i) I get zero values in some cells when I download live data to an Excel spreadsheet. I would like to replace these zeros with a very low number such as 0.01 by searching all cells in the columns populated by the downloaded data for zero values.

ii) If two adjacent values in two adjacent columns in the same row are equal (identical) and are subsequently used in a formula using subtraction it generates a zero, which can result in #DIV/0 in subsequent formulas. The equal value in the second column needs to be increased by a very small quantity such as 0.01 in some instances or decreased by 0.01 in other instances. Only a few relevant columns need to scanned and changes made where necessary.

The relevant columns in the spreadsheet need to be scanned for these two issues and changes made as necessary.

With Thanks,

Best Regards,

Michael
Moderators note: phone and email info removed

Hi, welcome to the forum

I have removed your phone no. and email addy, it is never a good idea to put sensitive data on a public forum

If two adjacent values in two adjacent columns in the same row are equal (identical) and are subsequently used in a formula using subtraction it generates a zero, which can result in #DIV/0 in subsequent formulas.

Instead of manipulating the values, why not add error-trapping to the subsequent formulas? Your profile indicates you are using office 2013, so perhaps try something like...

=IFERROR(your-formula,"")
or...
=IF(cell-generating-error=0,"",your-formula)

There are a few others, so there is no need to fiddle with the data