Presumably, either disc or M29 contains non-numeric (or non-boolean) data.
Does the following fix the problem?

=IF(ISNUMBER(M29*disc),M29-(M29*disc),M29)

--
Steve

"Neall" wrote in message
...
Trying to get rid of the #value to the cells that are not currently
populated
in cells with this if statement

=IF(M29-(M29*Disc),M29-(M29*Disc),M29)

Any help would be great

Thanks

--
Neall