Previous Topic Next Topic

Excel Help

Solved/Closed
femina Posts 5 Registration date Tuesday July 31, 2012 Status Member Last seen August 1, 2012 - Jul 31, 2012 at 06:41 PM
femina Posts 5 Registration date Tuesday July 31, 2012 Status Member Last seen August 1, 2012 - Aug 1, 2012 at 02:52 PM
Hello,



I have a schedule for the employees, and it contains seven columns as 7 days in a week. If any range of the columns contains text " OFF", i need to see the eighth column contain the result 0 or if all the range of columns is blank the result in the eighth column should be "8". Please help me to rectify the problem.

Eg: A1:F1 IS "OFF"(IN ANY COLUMN),"0" IN G1; IF BLANK THE G1 RESULT SHOULD BE "8".
Thanks.
Related:

2 responses

Answer 1 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Aug 1, 2012 at 02:56 AM
suppose data is like this

name mon tue wed thu fri
A off off
B
from A1 to F3
in G2 type this formula
=IF(COUNTIF(B2:F2,"off")>0,0,"")
copy G2 down.
0
Answer 2 / 2
femina Posts 5 Registration date Tuesday July 31, 2012 Status Member Last seen August 1, 2012
Aug 1, 2012 at 02:52 PM
Hi Venkat,

The answer which you posted is useful and solved my problem.

Thanks & Best Regards,
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses