CJ
Board Regular
- Joined
- Feb 22, 2002
- Messages
- 77
Please could someone help me with an IF STATEMENT, to me it seems impossible, but after seeing some of the IF STATEMENTS queries solved lately on this FORUM. I thought I would give this one a try.
What I am trying to do is this:
IF(C1&C2=”HOL”,”SICK”,”STUDY”, then the value of cell APRIL 02 B20)
IF NONE OF THE ABOVE APPLY THEN FOLLOW ON TO
IF(C1&C2=”UN-PAY”,”FLEXI”, then the value of 00:00)
IF NONE OF THE ABOVE APPLY THEN FOLLOW ON TO
C2-C1
I’m desperate for an answer!!!!!!!!
CHRIS
What I am trying to do is this:
IF(C1&C2=”HOL”,”SICK”,”STUDY”, then the value of cell APRIL 02 B20)
IF NONE OF THE ABOVE APPLY THEN FOLLOW ON TO
IF(C1&C2=”UN-PAY”,”FLEXI”, then the value of 00:00)
IF NONE OF THE ABOVE APPLY THEN FOLLOW ON TO
C2-C1
I’m desperate for an answer!!!!!!!!
CHRIS