LinkBack URL
About LinkBacks
My thinking is to try and fix the problem at the source, rather than try and figure out how to work around the problem
My thinking is to try and fix the problem at the source, rather than try and figure out how to work around the problem
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
lol what do you mean by "problem at the source"? How do I do that?
Do you think the problem at the source is the fact that I have #DIV/0! in some cells in the first place? I can't really fix that for my purpose.
Maybe someone could just tell me what Excel expects people to put in the [value_if_false] part of the [=IF...] function. Isn't there any way to communicate to Excel that I want it to perform a certain function ONLY on the values that the logical test returns as true, and simply ignore the false ones? How do I say "if false then ignore"? Has no one ever wanted to execute the command "if value is false than pretend that cell isn't even there and do the function on the other cells within the selected range"?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks