Thanks for the suggestion Steve, but it wont work,

I thought this might work
=IF(ISERROR(M29-(M29*Disc),M29-(M29*Disc),M29),"",M29-(M29*Disc),M29-(M29*Disc),M29)

However it keeps telling me that I have to many arguments, I need these
arguments included for other variables involved.

Any other suggestions?

Thanks in advance
--
Neall


"Neall" wrote:

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