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
Apr 25, 2019

I am adding my spreadsheet.

If there is no name in the Employee Name Column, then there would be no selections in C7:AG7 therefor there should be no value or a value of 0 in Perfect Attendance but the value should be hidden.

If there is a name in the Employee Name Column, and no selections in C7:AG7, then there should be a value of .5 in the Perfect Attendance Column.

If there is a name in the Employee Name Column, and either V, N, A, L, or H selected in C7:AG7, then there should be no value or a value of 0 in the Perfect Attendance Column and visible.

 

The premise here is: If they have perfect attendance for the month, they get a deduction of .5 from their "Total Accrued Points"

Resources