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:  Dave O (CycleZ…@yahoo.com)
Date: 3 May 2006

You can generally get around this type of hurdle with an IF statement:
for instance
=IF(Assumptions!AB18=0,"",1/Assumptions!AB18)
This returns a blank if AB18 equals zero, and performs the division if
AB18 is not zero.

Can you use that logic to flow through the various calculations in your
sprdsht?

Replies

In response to

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