Re: Getting rid of error messages while using IF statements

Giganews Newsgroups
Subject: Re: Getting rid of error messages while using IF statements
Posted by:  Bondi (mbondor…@hotmail.com)
Date: 3 May 2006

Hi,

You could use something like

=IF(ISERROR(C10),"",$A10*D$3,($A10-((D10/2)*$A10))*D$3)

This will give you a blank in case C10 is #DIV/0

Regards,
Bondi

Replies

None

In response to

Getting rid of error messages while using IF statements posted by theseandav…@gmail.com on 3 May 2006