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

Hi,
have you tried the IsError function in combination with the IF function?
HTH
Good luck

I will give it a shot Oliver I know zilch about Excel

Thank You

I know zilch + 1 about it
Good luck

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.