#value!

[SALO]

IN CELL AQ1 I WANT TO PUT A FORMULA THAT READS AI1*V1 WHICH WILL RETURN EITHER A NUMBER VALUE OR NOTHING. THE PROBLEM IS THAT SOMETIME WILL BE NO VALUE IN THESE CELLS SO i GET THE #VALUE! . COULD SOME ONE HELP ME TO ALTER OR ADD THE FORMULA IN AQ1 =AI1*V1 SO THAT IT RETURNS EITHER THE NUMBER OR NOTHING.

THANKS IN ADVANCE

 

[Kelbo]

The formula that you are looking for is:

=IF(ISERROR(AI1/V1),"",AI1/V1)

If you want to you can place reminder text between the "", such as "Data not available"

Kelbo

 

[Scott Huish]

If you're getting a #VALUE error there is probably an empty string "" in the cell, not nothing:

=IF(COUNT(A1,V1)=2,A1*V1,"")