Prev: Functions on filtered data
Next: reference cell from advanced filter
From: Ziggy on 25 Mar 2010 16:13
On Mar 25, 7:28 am, Mark D <Ma...(a)discussions.microsoft.com> wrote:
> Hi Again (where would I be without the help from this board)
>
> I have a forumula in a cell as follows
>
> =IF(ISNA(VLOOKUP($A77,'Personal NFI
> 2010'!$1:$65536,14,FALSE)),"",VLOOKUP($A77,'Personal NFI
> 2010'!$1:$65536,14,FALSE))
>
> working absolutely perfectly and if there is no number to find the cell
> stays blank.
>
> I then have the following formula that links to the one above
>
> =IF(ISBLANK(K76),"",(K76/K57))
>
> Unfortunately if the cell is blank it's returning #VALUE!
>
> I need to get this removed as I can't sum the total of the rows if there are
> VALUES in there
>
> Again thanks for any help
>
> Mark

You could also replace the "" in your formula with a 0, i.e., a value.
Tou can't divide a text by a value hence the error.
First  |  Prev  | 
Pages: 1 2
Prev: Functions on filtered data
Next: reference cell from advanced filter