showing value error in subtraction

[srirajsa]

Sir,


I have some cells to substract which also include blank cells so the error is showing as #value so please help me

thanks


srinivas

 

[NARAYANK991]

Hi Srinivas ,

If you upload your workbook , you can get a proper answer.

Narayan

 

[udprocks]

hallo dear,

can u please upload a sample file ....?

 

[srirajsa]

sir

this is the FILE

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[srirajsa]

Hi ,

See if this is OK.

Narayan

 

[srirajsa]

thank you narayan sir if you have time can you explain how it calculates

regards,

srinivas

 

[Somendra Misra]

Hi Srinivas,

I think you have copy and pasted this data from net page into Excel, so the cells where where excel is showing blank, actually when pasting data there was nothing and a null string "" got replaced there, so you are trying to do mathematical operation on numbers+strings, this will give you error.

Regards,

 

[srirajsa]

thanks for the detail sir