Hi,

I have cells showing #VALUE!, because the cell it is referencing is
blank (i think this the cause), is there a way for it not to show. I
have used IF statements in the past for simple formula's but the
formula for this is a bit complicated (thanks Biff), thanks for any
assistance.

Regards

David


--
dgraham
------------------------------------------------------------------------
dgraham's Profile: http://www.excelforum.com/member.php...o&userid=33138
View this thread: http://www.excelforum.com/showthread...hreadid=531161

Hi David,

=IF(ISERROR(yourcell),"",yourcell)

HTH
Carim


--
Carim
------------------------------------------------------------------------
Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259
View this thread: http://www.excelforum.com/showthread...hreadid=531161

Hi

Wrap your formula in this:
=IF(ISERROR(yourformula),"",yourformula)

Andy.

"dgraham" wrote in
message ...

Hi,

I have cells showing #VALUE!, because the cell it is referencing is
blank (i think this the cause), is there a way for it not to show. I
have used IF statements in the past for simple formula's but the
formula for this is a bit complicated (thanks Biff), thanks for any
assistance.

Regards

David


--
dgraham
------------------------------------------------------------------------
dgraham's Profile:
http://www.excelforum.com/member.php...o&userid=33138
View this thread: http://www.excelforum.com/showthread...hreadid=531161

Hi,

You can use:
=IF(ISERROR(YourReference),"",YourReference)

Regards,
Bondi

Thanks Carim,

this is the formula i've got, tried inserting the iserror you gave but
got an error.
=IF(B3="","",MAX((Shed!$B$3:$E$46=B3)*(ROW($1:$44) ))&CHOOSE(MAX((Shed!$B$3:$E$46=B3)*(COLUMN(Shed!$B $3:$E$46))),"","D","C","B","A"))

Hope this may give you some idea.

Regards

David


--
dgraham
------------------------------------------------------------------------
dgraham's Profile: http://www.excelforum.com/member.php...o&userid=33138
View this thread: http://www.excelforum.com/showthread...hreadid=531161

You could use conditional formatting, with a formula of =ISERROR(A1) and set
the font colour to white.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dgraham" wrote in
message ...

Hi,

I have cells showing #VALUE!, because the cell it is referencing is
blank (i think this the cause), is there a way for it not to show. I
have used IF statements in the past for simple formula's but the
formula for this is a bit complicated (thanks Biff), thanks for any
assistance.

Regards

David


--
dgraham
------------------------------------------------------------------------
dgraham's Profile:
http://www.excelforum.com/member.php...o&userid=33138
View this thread: http://www.excelforum.com/showthread...hreadid=531161

Hi!

=IF(B3="","",MAX((Shed!$B$3:$E$46=B3)*(ROW($1:$44) ))&CHOOSE(MAX((Shed!$B$3:$E$46=B3)*(COLUMN(Shed!$B $3:$E$46))),"","D","C","B","A"))

The only thing that I can see (from the formula) that would cause an error
is if the bus number wasn't listed in Shed, then the Choose function would
cause the error.

So, try this:

=IF(OR(B3="",COUNTIF(Shed,B3)=0),"",MAX((Shed=B3)* (ROW($1:$44)))&CHOOSE(MAX((Shed=B3)*(COLUMN(Shed)) ),"","D","C","B","A"))

If that doesn't solve the problem I'd need to see the file to figure it out.

Biff

"dgraham" wrote in
message ...

Hi,

I have cells showing #VALUE!, because the cell it is referencing is
blank (i think this the cause), is there a way for it not to show. I
have used IF statements in the past for simple formula's but the
formula for this is a bit complicated (thanks Biff), thanks for any
assistance.

Regards

David


--
dgraham
------------------------------------------------------------------------
dgraham's Profile:
http://www.excelforum.com/member.php...o&userid=33138
View this thread: http://www.excelforum.com/showthread...hreadid=531161