My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 #Value!
|
|
 Jul 12 2007, 08:12 PM
Post
#1
|
|
|
UtterAccess VIP Posts: 12,201 From: Tacoma, WA.  |
Am getting #Value! from this expression can something be added that will change the cell to show just an empty cell ?
=IF((I4-F4)>800,800/2400,M4) Thank You |
 |
 
|
|
Jul 12 2007, 08:33 PM
Post
#2
|
|
|
UtterAccess VIP Posts: 31,413 From: NC, USA |
|
|
|
|
|
Jul 12 2007, 08:40 PM
Post
#3
|
|
|
UtterAccess VIP Posts: 12,201 From: Tacoma, WA. |
I will give it a shot Oliver I know zilch about Excel
Thank You |
|
|
|
|
Jul 12 2007, 08:49 PM
Post
#4
|
|
|
UtterAccess VIP Posts: 31,413 From: NC, USA |
I know zilch + 1 about it (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif)
Good luck |
|
|
|
|
Jul 13 2007, 01:55 AM
Post
#5
|
|
|
UtterAccess Ruler Posts: 1,183 From: Norfolk UK |
Hi John,
The ISERROR function although useful at times can sometimes be a bit overkill, especially if you have a lot of these formulas as it can then start to impact on performance. Looking at you formula it is most likely caused by one of two things: 1. One or both of H4 and I4 contain text. 2. Cell M$ contains the #Value! error. The first issue can easily be overcome by coercing the text values to a number (Note this only works if it is a number formatted as text). Try this: =IF((--I4)-(--F4)>800,1/3,M4) If it is the second issue, then you might need to step back to find out what is causing this error. Just my thoughts Stu. |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 20th June 2013 - 06:40 AM |