Jul 12 2007, 08:12 PM
Am getting #Value! from this expression can something be added that will change the cell to show just an empty cell ?
Jul 12 2007, 08:33 PM
have you tried the IsError
function in combination with the IF function?
Jul 12 2007, 08:40 PM
I will give it a shot Oliver I know zilch about Excel
Jul 12 2007, 08:49 PM
I know zilch + 1 about it
Jul 13 2007, 01:55 AM
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 it is the second issue, then you might need to step back to find out what is causing this error.
Just my thoughts