Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =VALUE(IF(IFERROR(SEARCH("k",D111),"g")="g",VALUE(LEFT(D111,LEN(D111)-(LEN(D111)-SEARCH("g",D111)+1)))/1000,VALUE(LEFT(D111,SEARCH("k",D111)-1))))*VALUE(IFERROR(RIGHT(D111,LEN(D111)-SEARCH("×",D111)),1))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement