Excel help please

[PC Solutions]

I havent looked at your spreadsheet at all
The link you provided was very good, Except for one thing, if you want it to do nothing if the condition tests true.

For example
if(iserr(a division by zero or other bad condition, "", otherwise caclulate it))
Watch the parenthesis. They are important

Basically the way the formula work is this:
If check for an error condition
What do you want to do if the error condition is true?
Most likely nothing, so give it a nul string
Thats ""

Else, what do you want to do if the error condition is false.
Like I said, Iserr is a great Excel function. I use it all the time






Glad it helped