Guanjin Peter
Active Member
- Joined
- May 21, 2008
- Messages
- 429
let's say cell a1 contains either the word: Leave OR HalfDay
cell b2 takes the value from a1 and divide by 2. ----------- b2=(a1/2)
can I assign
leave=1
halfDay=0.5
so if a1 contains the word leave, b2 will be 0.5
if a1 contains the word Half-day, b2 will be 0.25
cell b2 takes the value from a1 and divide by 2. ----------- b2=(a1/2)
can I assign
leave=1
halfDay=0.5
so if a1 contains the word leave, b2 will be 0.5
if a1 contains the word Half-day, b2 will be 0.25