How do I add iserr or iserror to this
What values are in M29 and disc?
--
Steve
"Neall" wrote in message
...
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
|