Hey all,
I have a problem, i need to put some if statements in a ref cell, but i have 10, and can only put 7, help!!
i have:
=IF(D3="SICK",C3,IF(D3="HOLS (all day)",C3,IF(D3="FLEX (all day)",C3,IF(D3="HOLS (am)",C3/2,IF(D3="HOLS (pm)",C3/2,IF(D3="FLEX (am)",C3/2,IF(D3="FLEX (pm)",C3/2," ")))))))
I need to get:
Sick
Hols (all day)
Hols (am)
Hols (pm)
Flex (all day)
Flex (am)
Flex (pm)
Other (all day)
Other (am)
Other (pm)
the cell it refs (C32) counts the hours, so for a all day its counts the whole cell, but for a am or pm it counts then divides by 2, so thats quite essential too!
I have a problem, i need to put some if statements in a ref cell, but i have 10, and can only put 7, help!!
i have:
=IF(D3="SICK",C3,IF(D3="HOLS (all day)",C3,IF(D3="FLEX (all day)",C3,IF(D3="HOLS (am)",C3/2,IF(D3="HOLS (pm)",C3/2,IF(D3="FLEX (am)",C3/2,IF(D3="FLEX (pm)",C3/2," ")))))))
I need to get:
Sick
Hols (all day)
Hols (am)
Hols (pm)
Flex (all day)
Flex (am)
Flex (pm)
Other (all day)
Other (am)
Other (pm)
the cell it refs (C32) counts the hours, so for a all day its counts the whole cell, but for a am or pm it counts then divides by 2, so thats quite essential too!