On 28 Mar 2006 02:38:42 -0800, "Pete_UK" wrote:

You were trying to divide by L8, which you said was nothing. Your
amended formula has detected that. If you wanted the ISERROR function
to work, you should have done this:

=IF(ISERROR((($A$1*660)-K8*10)/L8),"",(($A$1*660)-K8*10)/L8)

Hope this helps.

Pete

So you're saying that if there is a formula in the cell L8 then that
isn't really nothing? Or are you saying that you can't divide by 0?

If you select L8 and hit the delete key, does your original formula work?

I'm guessing that the cell wasn't really empty.


Same question I guess. There was a formula in L8, but there wasn't a
value because it was on a blank line.

Just trying to understand. Thanks for the help.

Roger