Forum Discussion

RRCIT's avatar
RRCIT
Copper Contributor
Apr 25, 2019
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.  ...
excel
Formulas and Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Apr 26, 2019

    RRCIT 

     

    The revised formula for AJ7 would be:

    =(COUNTA(C7:AG7)=0)*(B7<>0)*0.5
RRCIT's avatar
RRCIT
Copper Contributor
May 01, 2019

Detlef_Lewin 

OK. I see it seems to work however, I don't quite get this part: 'Employee Names'!$A$2:$C$3,3,FALSE)) ..

Can you break it down for me? I would think it should be $A$2:$C$2, for Employee 1 and

$A$3:$C$3, for Employee 2.... and what is the ,3, prior to the FALSE referring to?

 

Also, now there is a #N/A in the remaining cells for columns AI and AJ where there are no employees.

 

Not quite sure why my copy and paste didn't work....

RRCIT's avatar
RRCIT
Copper Contributor
May 01, 2019

RRCIT 

Also the months following the hire date April - Dec are not accruing perfect attendance points for Employee 2 and should be....

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    May 01, 2019
    This seems to be a perpetual conversation. I hereby admonish you to start a new one, given that you terminated this yourself.

Resources