#value error

[Darts via OfficeKB.com]

In Cell R6 is N/a R3 is blank. The answer in R7 should return blank and it
retruns with #value errorT
Here is the formula I am using. I tried different IF and If(ISNA) and still
not working justdifferent errors.
R6*R$3 which is returning a value of #value. I would like that to return
blank

thanks

 

[Max]

In Cell R6 is N/a R3 is blank.
The answer in R7 should return blank and it
returns with #value errorT
Here is the formula I am using.
I tried different IF and If(ISNA) and still
not working just different errors.
R6*R$3 which is returning a value of #value.
I would like that to return blank

Try in R7: =IF(ISERROR(R6*R$3),"",R6*R$3)

 

[Darts via OfficeKB.com]

In Cell R6 is N/a R3 is blank.
The answer in R7 should return blank and it

[quoted text clipped - 4 lines]

R6*R$3 which is returning a value of #value.
I would like that to return blank

Try in R7: =IF(ISERROR(R6*R$3),"",R6*R$3)

Thanks Much!!!!!!!!!!!!!!!!!Your a life saver!!!!!!!!!!!!!!!

 

[Darts via OfficeKB.com]

In Cell R6 is N/a R3 is blank.
The answer in R7 should return blank and it

[quoted text clipped - 4 lines]

R6*R$3 which is returning a value of #value.
I would like that to return blank

Try in R7: =IF(ISERROR(R6*R$3),"",R6*R$3)

Thanks Much!!!!!!!!!!!!!!!!!Your a life saver!!!!!!!!!!!!!!!

 

[Max]

Thanks Much!!!!!!!!!!!!!!!!!Your a life saver!!!!!!!!!!!!!!!

Glad it worked <g> !