Thread
:
Getting rid of error messages while using IF statements
View Single Post
#
5
Posted to microsoft.public.excel.misc
Bondi
Posts: n/a
Getting rid of error messages while using IF statements
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
Reply With Quote
Getting rid of error messages while using IF statements