#value error

  • Thread starter Thread starter Darts via OfficeKB.com
  • Start date Start date
D

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
 
Darts via OfficeKB.com said:
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
Click to expand...

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

---
 
Max said:
In Cell R6 is N/a R3 is blank.
The answer in R7 should return blank and it
Click to expand...
[quoted text clipped - 4 lines]
R6*R$3 which is returning a value of #value.
I would like that to return blank
Click to expand...

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

---
Click to expand...
Thanks Much!!!!!!!!!!!!!!!!!Your a life saver!!!!!!!!!!!!!!!
 
Max said:
In Cell R6 is N/a R3 is blank.
The answer in R7 should return blank and it
Click to expand...
[quoted text clipped - 4 lines]
R6*R$3 which is returning a value of #value.
I would like that to return blank
Click to expand...

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

---
Click to expand...
Thanks Much!!!!!!!!!!!!!!!!!Your a life saver!!!!!!!!!!!!!!!
 
Back
Top