When using [=IF(ISNUMBER, ], how can I tell Excel to ignore a cell when [value_if_false]?

Hello all,

I have Excel 2010 and I am using the function [=IF(ISNUMBER, (T.TEST((D6,D15),(I6,I15),2,3)), [value_if_false]]

The range of cells I've selected for the T.TEST to performed on do not all contain numbers - some of those cells say #DIV/0! because they have a formula in them, which references cells that have not been populated with numbers. I would like Excel to just perform a T.TEST on the cells that contain numbers. What do I put in the part of the function that says [value_if_false] if I just want Excel to ignore everything that is not a number?

I'll attach a simplified version of my spreadsheet.

Maybe I'm using the wrong function to achieve my goal. If you have suggestions for how my goal can be done better, please, do tell me! I know I can always ONLY select the cells that have numbers in them, but that would be VERY time consuming and impractical for me. So, please, help me find out how to do a T.TEST while ignoring some cells that are not numbers.


THANK YOU SO MUCH IN ADVANCE FOR ANY HELP! I will really appreciate it and provide feedback!

Hi FDibbins, thank for the reply!

Yeah, maybe the test is called TTest in the 2007 version. It doesn't really matter what the test is, since the problem I have is regarding what to put in the [value_if_false] part of the [=IF...] function which holds my desired T.TEST.

I tried your formula [=IF(C6="","",100-(B6/C6)*100)] and it turned all the #DIV/0! into blank cells, but it didn't solve my problem because I still don't know how to tell Excel to ignore blank cells in a string of references.

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"?

Ok, yes, good idea!

I did that and my formulas all failed to work . Even the simplest T.TEST formula without any IF formulas specifying conditions.... So now i'm just even more confused...

Glenn Kennedy, you might be right! When I selected a continuous range, the T.TEST worked!

Now, instead of selecting non-adjacent cells, I can just paste all my values into one place and then select them. BUT, I still have one problem left! If I do this, I will still get blank cells, so is there any way to make the T.TEST ignore blank cells?


Thank you so much, everyone who helped! I would consider this solved only after I figure out how to make the T.TEST ignore non-numbers.

Wait, everyone! I got it!!

Excel does allow T.TEST to ignore blank numbers!!! OMG I AM SO HAPPY ABOUT THIS!!!

Although my original question wasn't solved (maybe I wasn't even asking it right, or maybe the problem was something else besides what I thought...), but I'm making this as solved because there's a really simple way for me to achieve my goal - just make it so that all the cells I wanna do a T.TEST on are adjacent.

Sorry for being a noob. And thank you!