If formula to replace the #N/A value
 

This might suffice:
In C2: =IF(ISNA(B2),0,A2)
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Casper" wrote:
Hi, I have been trying to work out the correct way of creating an if formula
to no success, it's probably not that difficult but hope you can help

I have a few columns with info that has got vlookup formulas in them and
some of the cells will have a #N/A value but will have the correct values
after a few days of data entering, I am trying to create the if formula so
that where there is a #N/A value to replace it with anoter cells value for
example;

A B C
Credit Value Date Total
1 12/01/2007 1
2 #N/A 0

if there is a date in the date column(B) then I want the value of column A
to be placed in clumn C but if there is a #N/A in column B the value in C
must be 0

Please help
Regards
Casper

If formula to replace the #N/A value
 

Brilliant thanx Max

"Max" wrote:

This might suffice:
In C2: =IF(ISNA(B2),0,A2)
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Casper" wrote:
Hi, I have been trying to work out the correct way of creating an if formula
to no success, it's probably not that difficult but hope you can help

I have a few columns with info that has got vlookup formulas in them and
some of the cells will have a #N/A value but will have the correct values
after a few days of data entering, I am trying to create the if formula so
that where there is a #N/A value to replace it with anoter cells value for
example;

A B C
Credit Value Date Total
1 12/01/2007 1
2 #N/A 0

if there is a date in the date column(B) then I want the value of column A
to be placed in clumn C but if there is a #N/A in column B the value in C
must be 0

Please help
Regards
Casper

If formula to replace the #N/A value
 

welcome, Casper.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Casper" wrote in message
...
Brilliant thanx Max