Build me an excel formula to look at a cell and output the value based on the results of a formula
£10-20 GBP
货到付款
I’m trying to use a formula to look at a cell on the "Data" sheet and output a value based on the formula on the "Result" sheet. The formula I’m trying to use is one that would allow me to look to see if “Kbbs” is in the cell and if so, remove “Kbbs” text from the cell to leave a value and then divide the resulting value by 1024. If there is no “Kbbs” then look for “Mbbs” if found then remove the text and display the value.
Aim is to cleanse data by removing text and get values in the same scale
Example cell value: 854Kpps or 1.2Mpps
Formula attempted: =IFS(SEARCH("Kpps",Data!F15),((SUBSTITUTE(Data!F15,"Kpps","")))/1024, SEARCH("Mpps",Data!F15),((SUBSTITUTE(Data!F15,"Mpps",""))))
Any help would be appreciated – I can only seem to get the “Kpps” side to work and not “Mpps” just get “#VALUE!” error
Ive tried OR and IF functions to
Thanks in advance
Craig
项目ID: #26335272
关于项目
授予:
Hi there, I am an expert in this . I have gone through the project description and can help you on this project. Thanks, Jayant
有7名威客正在参与此工作的竞标,均价£17/小时
Hi, I have good experience of Data processing, Data entry & Excel. Currently i working with respective company. same work also there. Please give me your project.