Hide #VALUE! from cells
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 |
Hide #VALUE! from cells
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 |
Hide #VALUE! from cells
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 |
Hide #VALUE! from cells
Hi,
You can use: =IF(ISERROR(YourReference),"",YourReference) Regards, Bondi |
Hide #VALUE! from cells
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 |
Hide #VALUE! from cells
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 |
Hide #VALUE! from cells
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 |
All times are GMT +1. The time now is 07:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com