Hi,
please find the attached sheet. i have a cell value like this 16*2*3.5. i want to multiple this value.
Hi,
please find the attached sheet. i have a cell value like this 16*2*3.5. i want to multiple this value.
Try this.......
=IF(COUNTIF(A2,"*")<1,A2,IF(LEN(A2)-LEN(SUBSTITUTE(A2,"*",""))<2,(LEFT(A2,FIND("*",A2,1)-1)+0)*RIGHT(A2,LEN(A2)-FIND("*",A2))+0,(LEFT(A2,FIND("*",A2,1)-1)+0)*(MID(A2,FIND("*",A2)+1,FIND("*",A2,FIND("*",A2)+1)-FIND("*",A2)-1)+0)*(RIGHT(A2,LEN(A2)-FIND("*",A2,FIND("*",A2)+1))+0)))
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks