Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =IF(AND(VALUE(RIGHT(C13, 1))>0, VALUE(RIGHT(C13, 1))<3), LEFT(C13,7)&0,
- IF(AND(VALUE(RIGHT(C13, 1))>3, VALUE(RIGHT(C13, 1))<6), LEFT(C13,7)&3,
- IF(AND(VALUE(RIGHT(C13, 1))>6, VALUE(RIGHT(C13, 1))<10), LEFT(C13,7)&6, C13)))
Add Comment
Please, Sign In to add comment