Forum Discussion
Solved
Excel Formulas
Excel 2013: I want a cell to be blank or have a value based on data/no data in a specific cell and data/no data in a range of cells. So in cell AJ7 I want either a numerical value or no value. ...
RRCIT , it's too hard to understand what is the logic behind without the sample file. Regarding the last formula
=IF(AND(COUNTA('Employee Names'!B7="1")),C7:AG7,"0",".5")
Within it 'Employee Names'!B7="1" returns TRUE or FALSE, COUNTA on it will be always 1 since it always have one "not empty" argument.
Next, you have AND(1) which always return TRUE. Thus your formula is
=IF(TRUE,C7:AG7,"0",".5")
That doesn't work - you have 4 arguments instead of 3 required.
Perhaps you mean
=IF(AND( ('Employee Names'!B7=1), (COUNTA(C7:AG7)=1) ) ,0 ,0.5)
I have already tried that formula and it doesn't work either. I have updated my post with additional info and a copy of the spreadsheet. Detlef Lewin provided a formula that does what I am looking for, but it breaks Columns AF/AG (causes a #VALUE!) to return into the empty cells.