How do you you leave a cell blank in case of an error? Currently i use =Errorif(cell; replacement value if there is an error) . I cant seem to make the cell blank.
This is problematic because i use =Average() on the columns and it will also use the errorif cells when they aren't blank
Last edited by Cerberus; 06-30-2010 at 01:30 PM.
=IERROR(expression, "")
The result is not a blank cell (it's a formula that returns a null string), but it's ignored by AVERAGE.
Entia non sunt multiplicanda sine necessitate
That worked perfectly thanks for the quick reply
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks